| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Hu, Patricia" <Patricia(dot)Hu(at)finra(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: relation create time |
| Date: | 2017-05-10 16:31:50 |
| Message-ID: | 804200a3-3722-ec73-60b1-3c1bfd0b3422@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-05-10 16:34:45 | Re: Upgrading postgresql minor version |
| Previous Message | Peter Eisentraut | 2017-05-10 16:30:54 | Re: character encoding of the postgres database |