Search Postgresql Archives

Re: Date created for tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxx> 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

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux