Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Table create time - Mailing list pgsql-general

From hamann.w@t-online.de
Subject [GENERAL] Table create time
Date
Msg-id wolfgang-1170831085609.A016879@noten19.local
Whole thread Raw
Responses Re: [GENERAL] Table create time  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
Re: [GENERAL] Table create time  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: [GENERAL] Table create time  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
Hi,

is there a way to add a table create (and perhaps schema modify) timestamp to the system?
I do occasionally create semi-temporary tables (meant to live until a problem is solved, i.e. longer
than a session) with conveniently short names.
Also, is there a simple query to identify tables without a table comment? (so a weekly cron
could remind me of tables that are already a few days old but have no explanatory comment)

I am running PG 9.3

Best regards
Wolfgang Hamann

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: [GENERAL] clustered index benchmark comparing Postgresql vs Mariadb
Next
From: "Charles Clavadetscher"
Date:
Subject: Re: [GENERAL] Table create time