object creation timestamp?

#1

Hi, is it possible to find out when an object (e.g., schema, table,
trigger, etc.) was created? I've looked through the pg_catalog table
and cannot find a timestamp column -- is this information maintained
anywhere?

Mark

#2

mark.greenbank (AT) gmail (DOT) com <mark.greenbank (AT) gmail (DOT) com> wrote:

Quote:

Hi, is it possible to find out when an object (e.g., schema, table,
trigger, etc.) was created? I've looked through the pg_catalog table
and cannot find a timestamp column -- is this information maintained
anywhere?

No. Sorry.

Yours,
Laurenz Albe

#3

begin mark.greenbank (AT) gmail (DOT) com schrieb:

Quote:

Hi, is it possible to find out when an object (e.g., schema, table,
trigger, etc.) was created? I've looked through the pg_catalog table
and cannot find a timestamp column -- is this information maintained
anywhere?

No, but you can log all DDL-statements, with timestamp.

end
Andreas
--
Andreas Kretschmer
Linux - weil ich es mir wert bin!
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

object creation timestamp?

comp.databases.postgresql comp.databases.postgresql

object creation timestamp? - 09-20-2007 , 07:15 AM

Re: object creation timestamp? - 09-20-2007 , 07:48 AM

Re: object creation timestamp? - 09-21-2007 , 12:20 AM