Re: Date created for tables

Поиск
Список
Период
Сортировка
От Justin
Тема Re: Date created for tables
Дата
Msg-id CALL-XeNvbwTv3_SXsYzTNZqw-3kcG-m7XNUKjVtdJ3K9-Jg=5w@mail.gmail.com
обсуждение исходный текст
Ответ на Date created for tables  (Chloe Dives <Chloe.Dives@cantabcapital.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Date created for tables
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Date created for tables