Re: Table create time

On 31/08/2017 09:56, hamann(dot)w(at)t-online(dot)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