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
> 


FAQ