get last timestamp of table ddl

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема get last timestamp of table ddl
Дата
Msg-id CAKoxK+5uz67DxYcF=6ese6imi7ovHoqwjB+YE4X46sNv_9KN0w@mail.gmail.com
обсуждение исходный текст
Ответы Re: get last timestamp of table ddl
Re: get last timestamp of table ddl
Список pgsql-general
Hi all,
I think I already know the answer, however I came across this table in
Oracle <https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_2005.htm#i1583352>
that has two columns that triggered my attention: CREATED and
LAST_DDL_TIME.
Apart from being dates (in the Oracle way), they store the time of
creation and last modification to the table structure.
I don't have any particular use case except from blaming someone about
a change in the database structure, however I'm curious: is there a
smarter way to achieve this in PostgreSQL than simply relying on logs
and commit timestamps?

Luca



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Max connections reached without max connections reached
Следующее
От: Shaozhong SHI
Дата:
Сообщение: How to set alias data type?