From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | Sanjay Minni <sanjay(dot)minni(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: any default columns for tracking / auditing purpose |
Date: | 2021-11-20 14:35:57 |
Message-ID: | 73BE98A3-C0B6-47F4-A6EB-5FE18C77F880@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Nov 20, 2021, at 6:50 AM, Sanjay Minni <sanjay(dot)minni(at)gmail(dot)com> wrote:
>
>
> 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)
>
Never ever re-use an id. There are lots of them. If you need lots and lots of them use UUID.
> with warm regards
> Sanjay
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2021-11-20 16:13:13 | Re: insert column monetary type ver 2 |
Previous Message | Дмитрий Иванов | 2021-11-20 14:32:54 | Re: insert column monetary type ver 2 |