Get current_user in statistics

From: th(at)gesteam(dot)fr
To: pgsql-admin(at)postgresql(dot)org
Subject: Get current_user in statistics
Date: 2009-08-13 14:12:32
Message-ID: 4A841F50.9060508@gesteam.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-08-13 14:59:11 Re: "Too many open files in system" error
Previous Message Gábor SZŰCS 2009-08-13 08:48:21 Re: Replication for R/W offline use