Thread: Need to trace the logs
Hi Team,
We are using a postgresql database with 9.6.1 version, any way to trace the last modified object, procedure in PostgreSQL.
Regards,
Nandhakumar B
On Thu, Oct 15, 2020 at 05:25:11PM +0530, nandha kumar wrote: > Hi Team, > We are using a postgresql database with 9.6.1 version, any way to > trace the last modified object, procedure in PostgreSQL. well, you can log all queries, and extract the info from logs. If by "object" you mean table/row - you can do it with triggers. Best regards, depesz
čt 15. 10. 2020 v 15:51 odesílatel hubert depesz lubaczewski <depesz@depesz.com> napsal:
On Thu, Oct 15, 2020 at 05:25:11PM +0530, nandha kumar wrote:
> Hi Team,
> We are using a postgresql database with 9.6.1 version, any way to
> trace the last modified object, procedure in PostgreSQL.
well, you can log all queries, and extract the info from logs.
If by "object" you mean table/row - you can do it with triggers.
Event triggers are designed for this purpose
Regards
Pavel
Best regards,
depesz