Re: How to find table creation time - Mailing list pgsql-admin

From reiner peterke
Subject Re: How to find table creation time
Date
Msg-id 14B72437-DECD-4311-B829-603364FAF3CE@drizzle.com
Whole thread Raw
In response to How to find table creation time  (Nik Tek <niktek2005@gmail.com>)
Responses Re: How to find table creation time  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
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, as  an operation like a vacuum full will
createa new file node. 
I haven't found a good way to work around this either.

Reiner

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

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



pgsql-admin by date:

Previous
From: Nik Tek
Date:
Subject: How to find table creation time
Next
From: Guillaume Lelarge
Date:
Subject: Re: How to find table creation time