Re: A question relative to creating an audit table

From: Vik Fearing <vik(at)postgresfriends(dot)org>
To: stan <stanb(at)panix(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: A question relative to creating an audit table
Date: 2020-02-27 22:53:38
Message-ID: 828ea45d-3126-e5d2-a235-6b8415e5f202@postgresfriends.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message sivapostgres@yahoo.com 2020-02-28 01:10:16 Re: Need to find the no. of connections for a database
Previous Message Tory M Blue 2020-02-27 22:45:25 Re: pg_upgrade custom table locations. Move table locations during upgrade?