On Mon, Nov 02, 2020 at 03:23:06PM +0530, paras paliya wrote:
> 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?
PostgreSQL doesn't keep that information.
You can:
1. set log_st
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"
À: pgsql-gene...@postgresql.org
Envoyé: Lundi