On 31/08/2017 09:56, haman...@t-online.de wrote:
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.
In FreeBSD you'd do smth like this to find the file creation time :
ls -lU <path to your cluster>/data/PG_9.3_201306121/16425/12344
where 12344 is the filenode of the relation in question. In ext4 you may do
this albeit with more difficulty.
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
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general