[ADMIN] object creation date

2003-09-12 Thread Marie G. Tuite
How can I identify table creation date as opposed to last modified? Thanks. -Marie ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] object creation date

2003-09-12 Thread Peter Eisentraut
Marie G. Tuite writes: How can I identify table creation date as opposed to last modified? Not unless you keep track of it yourself. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives?

Re: [ADMIN] object creation date

2003-09-12 Thread Terry Hampton
Hello Marie, In most of my tables, I have the same two columns: lastupdateTIMESTAMP not null default ('now'::text)::timestamp(8), createdateTIMESTAMP not null default ('now'::text)::timestamp(8)