Skip site navigation (1) Skip section navigation (2)

Re: Determine the date a table was defined/created.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Determine the date a table was defined/created.
Date: 2007-10-24 02:38:52
Message-ID: 21549.1193193532@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com> writes:
> I believe the date a table is defined is stored in one of the system
> catalogs.

You're mistaken.

You might be able to estimate it by comparing the table OID to the OIDs
of other tables --- that would at least give you a fix on the order of
creation.  But there's no timestamp as such.

If you have faithfully maintained PITR archives covering the time period
in question, then the information is theoretically available from those,
but I'm not aware of any tools that would easily pull it out for you.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Nis JørgensenDate: 2007-10-24 08:05:39
Subject: Re: Postgres Joins ?
Previous:From: David MonarchiDate: 2007-10-24 02:17:23
Subject: Determine the date a table was defined/created.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group