Postgres Pro
Downloads
Home   >   mailing lists

Re: Last updated time for a Schema of the table - Mailing list pgsql-general

From PALAYRET Jacques
Subject Re: Last updated time for a Schema of the table
Date
Msg-id 1319325393.24836507.1604316685851.JavaMail.zimbra@meteo.fr
Whole thread Raw
In response to Last updated time for a Schema of the table  (paras paliya <paliya.paras@gmail.com>)
List pgsql-general
Tree view
Hello,

I don't think so, as far as I know.
But, you can put in place some triggesr to do that.
i.e. https://www.postgresql.org/docs/13/plpgsql-trigger.html  https://wiki.postgresql.org/wiki/Audit_trigger
and so on

Regards
De: "paras paliya" <paliya.paras@gmail.com>
À: pgsql-general@postgresql.org
Envoyé: Lundi 2 Novembre 2020 10:53:06
Objet: Last updated time for a Schema of the table

Hi All,
I need the last updated time or alter time of the table. Like changing the column name or adding/deleting a column. Is there any table or view from which I can get?

Thanks,
Paras

pgsql-general by date:

Previous
From: paras paliya
Date:
Subject: Last updated time for a Schema of the table
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Last updated time for a Schema of the table