pid of current session?

From: Boris Popov <boris(at)procedium(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pid of current session?
Date: 2003-11-06 21:48:25
Message-ID: 69275458708.20031106134825@procedium.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig O'Shannessy 2003-11-06 21:53:18 Optimiser desicion bringing system to its knees?
Previous Message Ian Harding 2003-11-06 19:51:50 Re: Insert and obtain the pk