Re: relation create time

On Wed, May 10, 2017 at 12:31 PM, Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:

> On 5/10/17 12:05, Hu, Patricia wrote:
> > I am trying to find out when a table was created in postgresql. Thought
> > it would be easy (coming from Oracle world), but haven’t had any luck,
> > especially since we are on RDS and can’t peek at the timestamp on the
> > file system. Is this information stored anywhere in the catalog?
>
> It is not.
>
> > Or I
> > need to store it myself? Is there any plan to add such meta data
> > information to the catalog as a feature? Thanks a lot!
>
> You could write an event trigger to record it.
>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

*One option would be to set log_statement = 'ddl' , and make sure
log_line_prefix includes time, then you can review the log for creation
time.*

*Also, I have been requesting that feature for a long time, so if you want
to add your support, vote for it
athttps://postgresql.uservoice.com/forums/21853-general?filter=top&page=2
<https://postgresql.uservoice.com/forums/21853-general?filter=top&page=2>*

*and look for relcreate*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.