Re: get last timestamp of table ddl

On Wed, Nov 24, 2021 at 3:30 PM Achilleas Mantzios wrote: > You mean like trying to correlate pg_class.xmin with some timestamp via > track_commit_timestamp or other means? Pretty much yes: since pg_class and pg_attribute comes to my mind. Luca

Re: get last timestamp of table ddl

On Wed, Nov 24, 2021 at 3:09 PM hubert depesz lubaczewski wrote: > You could add event triggers to achieve similar functionality. > https://www.depesz.com/2012/07/29/waiting-for-9-3-event-triggers/ > and > https://www.postgresql.org/docs/current/sql-createeventtrigger.html Thanks, I was ware of

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 that has two columns that triggered my attention: CREATED and LAST_DDL_TIME. That

Re: get last timestamp of table ddl

On Wed, Nov 24, 2021 at 02:53:24PM +0100, Luca Ferrari wrote: > Hi all, > I think I already know the answer, however I came across this table in > Oracle > > that has two columns that triggered my attention: CREAT

get last timestamp of table ddl

Hi all, I think I already know the answer, however I came across this table in Oracle that has two columns that triggered my attention: CREATED and LAST_DDL_TIME. Apart from being dates (in the Oracle way), they s