Re: Date created for tables

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(dot)Dives(at)cantabcapital(dot)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
>
>
>
>
>