Object Create Date

Hello,

Which data dictionary I have to query to determine the object creation date..

F.ex I would like to find out on which date table or Index has been created..

Thanks

Sameer
sameer_deshpande [ Mo, 19 Juli 2004 09:36 ] [ ID #453002 ]

Re: Object Create Date

Sameer Deshpande wrote:

> Hello,
>
> Which data dictionary I have to query to determine the object creation date..
>
> F.ex I would like to find out on which date table or Index has been created..

You can't.

Regards
Gaeatano Mendola
Gaetano Mendola [ Mo, 26 Juli 2004 01:35 ] [ ID #453117 ]

Re: Object Create Date

hi,

Gaetano Mendola wrote, On 7/26/2004 01:35:

> Sameer Deshpande wrote:
>
>> Hello,
>>
>> Which data dictionary I have to query to determine the object creation date..
>>
>> F.ex I would like to find out on which date table or Index has been created..
>
> You can't.

he can :) grab the object's OID from system tables and check the
corresponding file's create date.

C.
CoL [ Mo, 26 Juli 2004 03:09 ] [ ID #453120 ]
Datenbanken » comp.databases.postgresql.sql » Object Create Date

Vorheriges Thema: Trigger functions with dynamic SQL
Nächstes Thema: Please help - performance problems