On Fri, Sep 19, 2025 at 4:56 AM 張宸瑋 wrote:
> *log* the creation time of user accounts and database objects.
Yes, indirectly, via event triggers:
https://www.postgresql.org/docs/current/event-trigger-matrix.html
But that's specific to a DB, does [NOT fire for CREATE USER/ROLE][1],
only some objec
On Thursday, September 18, 2025, 張宸瑋 wrote:
>
>
> 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.
>
>
That information is not ca
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 the
