Re: A question relative to creating an audit table - Mailing list pgsql-general

From Vik Fearing
Subject Re: A question relative to creating an audit table
Date
Msg-id 828ea45d-3126-e5d2-a235-6b8415e5f202@postgresfriends.org
Whole thread Raw
In response to A question relative to creating an audit table  (stan <stanb@panix.com>)
List pgsql-general
On 27/02/2020 22:28, stan wrote:
> I ma considering setting up a function, and triggers to put a record in an
> audit table when certain tables are altered. I pretty much think I know how
> to do this, with one exception.

There are extensions out there that deal with this for you.  Here is
one: https://github.com/xocolatl/periods/

> Can a function, called by a trigger, determine what table it was called
> for?

Yes.
-- 
Vik Fearing



pgsql-general by date:

Previous
From: Tory M Blue
Date:
Subject: Re: pg_upgrade custom table locations. Move table locations during upgrade?
Next
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Need to find the no. of connections for a database