Postgres Pro
Downloads
Home   >   mailing lists

RE: user creation time for audit - Mailing list pgsql-general

From Boyapalli, Kousal
Subject RE: user creation time for audit
Date
Msg-id DB9PR08MB63464B285D5F0F74F97E1B8CC8CB9@DB9PR08MB6346.eurprd08.prod.outlook.com
Whole thread Raw
Responses Re: user creation time for audit  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-general
Tree view

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 !

 

Freundliche Grüße/Kind regards

Kousal Boyapalli

Database Administrator

 

Kousal.Boyapalli.ext@uniper.energy

 

Assigned by,

F_OI5-D3 Support Cross Functions

Sales&Trading IT

Uniper

 

www.uniper.energy

Uniper IT GmbH, Holzstraße 6, 40221 Düsseldorf, Germany; Sitz/Registered Office: Düsseldorf, Amtsgericht/District Court Düsseldorf HRB 78258;Geschäftsführung/Managing Directors: Damian Bunyan, Hans Pezold

Postanschrift/Postal address: Uniper IT GmbH,E.ON Platz 1, D-40479  Düsseldorf

 

Please consider the environment before printing this email.

 

Attachment

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Can we get rid of repeated queries from pg_dump?
Next
From: Julien Rouhaud
Date:
Subject: Re: user creation time for audit