That is crazy that creation time is not logg= ed anywhere.

<= i>One thing to note, you can log ddl changes in postgres. Some would argue = this should be on by default and i would agree.

In the postgres.conf>>

log_statement =3D ddl<= /div>

<= div id=3D"bloop_customfont" style=3D"margin: 0px;">Moving forward that w= ill give you the creation time of tables. Although I know your objective ma= y have been to go back in time:) Anyways I actually parse the logs ou= t and have an email sent to me if a DDL statement happens. Its a nice way t= o keep a pulse on schema changes or to catch someone =E2=80=9Csneaking in= =E2=80=9D a change. Or even think about data recovery, =E2=80=9Cwhat time d= id you drop that production table?=E2=80=9D is no longer a question. <= /i>

hopefully that ca= n help!
-jason&nb= sp;

=

That is crazy that creation = time is not logged anywhere.

One thing to note, you can log ddl changes in postgres. Some would arg= ue this should be on by default and i would agree.

In the postgres.conf>>

log_statement =3D ddl

Moving forward that will give you the creation time of table= s. Although I know your objective may have been to go back in time:) = Anyways I actually parse the logs out and have an email sent to me if a DDL= statement happens. Its a nice way to keep a pulse on schema changes or to = catch someone =E2=80=9Csneaking in=E2=80=9D a change. Or even think about d= ata recovery, =E2=80=9Cwhat time did you drop that production table?=E2=80= =9D is no longer a question.

hopefully that can help!

-= jason

On April 7, 2014 = at 11:04:21 AM, Steve Crawford (scrawford@pinpointresearch.com) wrote:

On 04/04/2014 04:39 PM, = Nik Tek wrote:
> Hi,
>
> Is there a way to find table creation time in postgres?
> pg version is 9.0
>
Not by some baked-in command but you can determine it from the logs if = =20
you have the appropriate log-settings and sufficient log-retention.

Cheers,
Steve

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

This transmission contains confidential = and privileged information intended solely for the party identified above. If you receive = this message in error, you must not use it or convey it to others. Please destroy it immediately and contact the se= nder at (303) 386-3955 or by return e-mail to the sender.
--534301bf_3d1b58ba_2ad6--