SQL call to get pid of current connection

Is there a function call that will return the pid of the postgres
process associated with the current client connection?

- DAP
------------------------------------------------------------------------
----------
David Parker Tazz Networks (401) 709-5130

On Thu, Jun 02, 2005 at 17:04:22 -0400,
David Parker <dparker(at)tazznetworks(dot)com> wrote:
> Is there a function call that will return the pid of the postgres
> process associated with the current client connection?

I thought I remembered seeing one, but I looked through the development
docs and didn't see a function or a GUC variable with that information.
It wouldn't be too hard to write a C or Perl function to get that
information.

On Thu, Jun 02, 2005 at 05:02:14PM -0500, Bruno Wolff III wrote:
> On Thu, Jun 02, 2005 at 17:04:22 -0400,
> David Parker <dparker(at)tazznetworks(dot)com> wrote:
> > Is there a function call that will return the pid of the postgres
> > process associated with the current client connection?
>
> I thought I remembered seeing one, but I looked through the development
> docs and didn't see a function or a GUC variable with that information.

Are you looking for pg_backend_pid()? It's documented in the
"Statistics Collector" section of the "Monitoring Database Activity"
chapter; it's been around since 7.3:

http://www.postgresql.org/docs/7.3/interactive/release-7-3.html
http://www.postgresql.org/docs/7.3/interactive/monitoring-stats.html
http://www.postgresql.org/docs/7.4/interactive/monitoring-stats.html
http://www.postgresql.org/docs/8.0/interactive/monitoring-stats.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

"David Parker" <dparker(at)tazznetworks(dot)com> writes:
> Is there a function call that will return the pid of the postgres
> process associated with the current client connection?

libpq makes this available as PQbackendPID(). Dunno about other
client libraries.

regards, tom lane