Re: get last timestamp of table ddl

On 24/11/21 3:53 μ.μ., Luca Ferrari wrote:
> 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.
That would be handy .. :(
> 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?
You mean like trying to correlate pg_class.xmin with some timestamp via track_commit_timestamp or other means?
>
> Luca
>
>

--
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt