On Mon, Aug 30, 2021 at 4:43 PM Boyapalli, Kousal <Kousal.Boyapalli.ext@uniper.energy> 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 Postgres doesn't keep track of object creation date. There are multiple discussions about that in the mailing-list archives if you're interested but mostly the reason is that it's not clear that a single creation date would suits everyone's need (for instance when doing backup/restore, should the creation date be reset or not?). 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.
