Re: Need to trace the logs

2020-10-15 Thread Pavel Stehule
čt 15. 10. 2020 v 15:51 odesílatel hubert depesz lubaczewski < dep...@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 Postgre

Re: Need to trace the logs

2020-10-15 Thread hubert depesz lubaczewski
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