Hello everyone,
I would like to ask if there are any built-in features or extensions in open-source PostgreSQL—aside from the AUDIT mechanisms—that allow us to query or log the creation time of user accounts and database objects.
The reason for this inquiry is that while audit logs do capture these events, they may eventually be rotated out or removed due to housekeeping policies. Having a dedicated table or view to permanently record the creation or modification time of accounts and objects would be very helpful for audit and security compliance purposes.
Thank you in advance for your insights!