Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\))
Subject: Re: How to find table creation time
From: reiner peterke <zedaardv@drizzle.com>
In-Reply-To: 
 <CAHySzWVNoyn803AOU3fU6yzjTa1bmQ28RED_+t3MKmCV7tgCSA@mail.gmail.com>
Date: Sat, 5 Apr 2014 08:26:47 +0200
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <14B72437-DECD-4311-B829-603364FAF3CE@drizzle.com>
References: 
 <CAHySzWVNoyn803AOU3fU6yzjTa1bmQ28RED_+t3MKmCV7tgCSA@mail.gmail.com>
To: Nik Tek <niktek2005@gmail.com>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi,

Unfortunately not. This is a feature that is lacking in postgres.

One could always look at the file node times, but this is unreliable too, a=
s  an operation like a vacuum full will create a new file node.
I haven't found a good way to work around this either.

Reiner=20
=20
On 5 apr 2014, at 01:39, Nik Tek <niktek2005@gmail.com> wrote:

> Hi,
>=20
> Is there a way to find table creation time in postgres?
> pg version is 9.0
>=20
>=20
> Thank you
> Nik


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin