On Wed, May 10, 2017 at 12:31 PM, Peter Eisentraut < peter.eisentr...@2ndquadrant.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@postgresql.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.