Postgres Pro
Downloads
Home   >   mailing lists

Get current_user in statistics - Mailing list pgsql-admin

From th@gesteam.fr
Subject Get current_user in statistics
Date
Msg-id 4A841F50.9060508@gesteam.fr
Whole thread Raw
List pgsql-admin
Tree view 
Hi,

The usename column in pg_stat_activity is the session_user.
Is there a way to get a column with the current_user (different after
the use of SET ROLE)?

Thanks
--
Thierry Hauchard
Gesteam

pgsql-admin by date:

Previous
From: Gábor SZŰCS
Date:
Subject: Re: Replication for R/W offline use
Next
From: Tom Lane
Date:
Subject: Re: "Too many open files in system" error