Hello,
Thursday, November 6, 2003, 1:48:25 PM, I wrote:
BP> Is there a way to tell which session from 'select * from
BP> pg_stat_activity' is a current session? Obviously if there's way
BP> to find out pid of a current session by some other means I could
BP> then look the rest in pg_stat_activity.
Please nevermind, I must have missed it in the docs the first time.
select * from pg_stat_activity where procpid = pg_backend_pid();
--
-Boris