From: | hamann(dot)w(at)t-online(dot)de |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Table create time |
Date: | 2017-08-31 11:03:08 |
Message-ID: | wolfgang-1170831130308.A036879@noten19.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> 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.
>>
Hello Achilleas,
many thanks for responding. There are two problems;
a) accessing the filesystem will likely require some extra effort (e.g. installing an untrusted programming
language)
b) a dump/restore will modify the dates
best regards
Wolfgang Hamann
From | Date | Subject | |
---|---|---|---|
Next Message | Condor | 2017-08-31 11:45:11 | Re: How to check streaming replication status |
Previous Message | Stefan Wagner | 2017-08-31 09:50:41 | ERROR: Undefined Reference to |