Postgres Pro
Downloads
Home   >   mailing lists

Re: Need to trace the logs - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Need to trace the logs
Date
Msg-id 20201015135133.GB32444@depesz.com
Whole thread Raw
In response to Need to trace the logs  (nandha kumar <bnandhakumardba@gmail.com>)
Responses Re: Need to trace the logs  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: nandha kumar
Date:
Subject: Need to trace the logs
Next
From: Pavel Stehule
Date:
Subject: Re: Need to trace the logs