On Nov 24, 2004, at 7:07 PM, Najib Abi Fadel wrote:
> Is there a to get the row creation time if we know it's object ID ??
Only if you have a timestamp column on the table that records the
creation time. For example,
create table foo (
foo_id serial not null unique
, created_timestamp timestamptz not null
default current_timestamp
) without oids;
Some people also like to include a modified_timestamp column, which can
easily be updated via an after update trigger.
hth
Michael Glaesemann
grzm myrealbox com