Thread: object creation date

How can I identify table creation date as opposed to last modified?

Thanks.

-Marie

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

    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
>