Re: user creation time for audit

2021-08-30 Thread Julien Rouhaud
On Mon, Aug 30, 2021 at 5:24 PM Vijaykumar Jain wrote: > > On Mon, 30 Aug 2021 at 14:39, Julien Rouhaud wrote: >> >> >> The easy way around that is to track those events yourself with the >> rules that suit your needs, which can be done easily using an event >> trigger. > > > Please correct me if

Re: user creation time for audit

2021-08-30 Thread Vijaykumar Jain
On Mon, 30 Aug 2021 at 14:39, Julien Rouhaud wrote: > > The easy way around that is to track those events yourself with the > rules that suit your needs, which can be done easily using an event > trigger. > Please correct me if I am missing anything, but the doc said, event triggers are not allo

Re: user creation time for audit

2021-08-30 Thread Julien Rouhaud
On Mon, Aug 30, 2021 at 4:43 PM Boyapalli, Kousal wrote: > > We are looking for the user creation date > > Tried from both from pg admin and psql by using > > select * from pg_catalog.pg_user and /du, /du+ we were able to get the > users but is there a way where we can get the creation date

RE: user creation time for audit

2021-08-30 Thread Boyapalli, Kousal
Hi Team, We are looking for the user creation date Tried from both from pg admin and psql by using select * from pg_catalog.pg_user and /du, /du+ we were able to get the users but is there a way where we can get the creation date Can any one please help/any suggestions Thanks in Advance !