Re: A question relative to creating an audit table

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: A question relative to creating an audit table
Дата
Msg-id 828ea45d-3126-e5d2-a235-6b8415e5f202@postgresfriends.org
обсуждение исходный текст
Ответ на A question relative to creating an audit table  (stan <stanb@panix.com>)
Список 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 по дате отправления:

Предыдущее
От: Tory M Blue
Дата:
Сообщение: Re: pg_upgrade custom table locations. Move table locations during upgrade?
Следующее
От: "sivapostgres@yahoo.com"
Дата:
Сообщение: Re: Need to find the no. of connections for a database