Home > mailing lists

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

From	Pavel Stehule
Subject	Re: Need to trace the logs
Date	October 15, 2020 16:55:34
Msg-id	CAFj8pRCNKLnu-KFGKS5QQW+gxoGF_WetRVUV0OD9vHeRTuq4oA@mail.gmail.com Whole thread Raw
In response to	Re: Need to trace the logs (hubert depesz lubaczewski <depesz@depesz.com>)
List	pgsql-general

Tree view

č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

https://www.postgresql.org/docs/9.6/event-triggers.html

Regards

Pavel

Best regards,

depesz

pgsql-general by date:

From: hubert depesz lubaczewski
Date: 15 October 2020, 16:51:33
Subject: Re: Need to trace the logs

From: "James B. Byrne"
Date: 15 October 2020, 17:07:22
Subject: character datatype explaination sought

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

Previous

Next