Hello Marie,
In most of my tables, I have the same
two columns: lastupdate TIMESTAMP not null default
('now'::text)::timestamp(8),
createdate TIMESTAMP not null default
('now'::text)::timestamp(8) "createdate" is only written once, of course.
and populates automatically. I have created a trigger to automaticaly change
"lastupdate" every time the record is updated. I re-read your question however - and you mention
*table* creation date. Do you have tables
that are created dynamically ? Could you provide
a bit more detail ? How is table creation
date useful for you ?Terry
Marie G. Tuite wrote:
How can I identify table creation date as opposed to last modified?
Thanks.
-Marie
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
