Re: Date created for tables - Mailing list pgsql-general

From Justin
Subject Re: Date created for tables
Date
Msg-id CALL-XeNvbwTv3_SXsYzTNZqw-3kcG-m7XNUKjVtdJ3K9-Jg=5w@mail.gmail.com
Whole thread Raw
In response to Date created for tables  (Chloe Dives <Chloe.Dives@cantabcapital.com>)
List pgsql-general
Hi Tom 

can't we get access to this information in a backwards way by using pg_xact_commit_timestamp()  then query the system catalog tables xmin entry for the relevant object???

this requires turning on pg_xact_commit_timestamp  https://www.postgresql.org/docs/current/runtime-config-replication.html

will not show the creation date as it will be lost after an update and vacuum ...





On Thu, Dec 5, 2019 at 12:10 PM Chloe Dives <Chloe.Dives@cantabcapital.com> wrote:

Having moved to PostgreSQL from Oracle a few years ago I have been generally very impressed by Postgres, but there are a few things that I still miss. One of those is being able to see the created and last modified dates for database objects.

 

Is this something that has been considered for implementation?

 

Thanks in advance,

Chloe

 

 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Date created for tables
Next
From: Adrian Klaver
Date:
Subject: Re: Date created for tables