| From: | PALAYRET Jacques <jacques(dot)palayret(at)meteo(dot)fr> |
|---|---|
| To: | paras paliya <paliya(dot)paras(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Last updated time for a Schema of the table |
| Date: | 2020-11-02 11:31:25 |
| Message-ID: | 1319325393.24836507.1604316685851.JavaMail.zimbra@meteo.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)paras(at)gmail(dot)com>
À: pgsql-general(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2020-11-02 12:36:23 | Re: Last updated time for a Schema of the table |
| Previous Message | paras paliya | 2020-11-02 09:53:06 | Last updated time for a Schema of the table |