object creation date
object creation date
От:
"Marie G. Tuite" <marie.tuite@edisonaffiliates.com>
Дата:
How can I identify table creation date as opposed to last modified? Thanks. -Marie
Re: object creation date
От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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 peter_e@gmx.net
Re: object creation date
От:
Terry Hampton <thampton@limacorp.com>
Дата:
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
>