On Thu, Aug 31, 2017 at 10:21 PM, Melvin Davidson <melvin6...@gmail.com> wrote: > Wolfgang, as David said, a column in pg_class for the creation time of a > table does not exist. I long ago requested that feature as it is > in other DB's (Oracle & MS SQL Server), but the main reason that it was not > done was that no one was interested in doing it.
Is there any need for a column in pg_class for that? You could just create an event trigger looking for CREATE TABLE as filter_value: https://www.postgresql.org/docs/9.6/static/sql-createeventtrigger.html And then have this event trigger just save the timestamp value of now() in a custom table with the name and/or OID of the relation involved. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
