On Wed, May 10, 2017 at 12:31 PM, Peter Eisentraut <peter.eisentraut@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@xxxxxxxxxxxxxx)
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 at
https://postgresql.uservoice.com/forums/21853-general?filter=top&page=2
https://postgresql.uservoice.
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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
