| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
| Cc: | nandha kumar <bnandhakumardba(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Need to trace the logs |
| Date: | 2020-10-15 13:55:34 |
| Message-ID: | CAFj8pRCNKLnu-KFGKS5QQW+gxoGF_WetRVUV0OD9vHeRTuq4oA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
čt 15. 10. 2020 v 15:51 odesílatel hubert depesz lubaczewski <
depesz(at)depesz(dot)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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James B. Byrne | 2020-10-15 14:07:22 | character datatype explaination sought |
| Previous Message | hubert depesz lubaczewski | 2020-10-15 13:51:33 | Re: Need to trace the logs |