get last timestamp of table ddl - Mailing list pgsql-general

From Luca Ferrari
Subject get last timestamp of table ddl
Date
Msg-id CAKoxK+5uz67DxYcF=6ese6imi7ovHoqwjB+YE4X46sNv_9KN0w@mail.gmail.com
Whole thread Raw
Responses Re: get last timestamp of table ddl  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: get last timestamp of table ddl  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Max connections reached without max connections reached
Next
From: Shaozhong SHI
Date:
Subject: How to set alias data type?