Обсуждение: pid of current session?

Hello pgsql-general,

Is there a way to tell which session from 'select * from
pg_stat_activity' is a current session? Obviously if there's way to
find out pid of a current session by some other means I could then
look the rest in pg_stat_activity.

Thanks!

--
-Boris

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