any default columns for tracking / auditing purpose

From: Sanjay Minni <sanjay(dot)minni(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: any default columns for tracking / auditing purpose
Date: 2021-11-20 13:50:00
Message-ID: CAMpxBom5Su6OJ+wfpq21-H7FVg5aXiDArv2bFJmmbq9cEwNukw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In Postgres 12 and up, are there any default columns available which could
be useful for tracking / auditing purposes ?
e.g.
- real user who entered / updated the data
- timestamp when data was updated / entered
where can i get a list of such default columns (if any) - which could be
accessed easily in user applications.

also what is the usual practice in creating userID's in a large
multi-tenanted applications with highly dynamically changing users (e.g
students who enroll and go off after some sometime), with all users having
the same access -
is a different userID created in the system for each user or is a common
postgresID used by the application and the application is responsible for
tracking individual users with its own userID. (this will reduce system
overhead)

with warm regards
Sanjay

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josef Šimánek 2021-11-20 14:18:09 Re: insert column monetary type ver 2
Previous Message Дмитрий Иванов 2021-11-20 12:45:03 insert column monetary type ver 2