Re: How to find table creation time

From: reiner peterke <zedaardv(at)drizzle(dot)com>
To: Nik Tek <niktek2005(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to find table creation time
Date: 2014-04-05 06:26:47
Message-ID: 14B72437-DECD-4311-B829-603364FAF3CE@drizzle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 create a 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(at)gmail(dot)com> wrote:

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2014-04-05 15:44:57 Re: How to find table creation time
Previous Message Nik Tek 2014-04-04 23:39:51 How to find table creation time