>you could just create an event trigger looking for CREATE TABLE as filter_value:
I have tried that. Unfortunately, I have been unable to extract the table name from the event because TG_TABLE_NAME is not available during an event trigger, albeit perhaps I am missing something? That being said, I still believe it is extra work that could easily be avoided and should be added to the postgresql catalogs simply to be more feature competitive with Oracle & SQL Server, as well as a boost to the PostgreSQL community. On Thu, Aug 31, 2017 at 10:54 AM, Michael Paquier <michael.paqu...@gmail.com > wrote: > 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 > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
