On 31/08/2017 09:56, hamann.w@xxxxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
