Re: Getting process id of a connection?

From: "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com>
To: "Bricklen Anderson" <banderson(at)presinet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting process id of a connection?
Date: 2008-01-04 23:17:33
Message-ID: b11ea23c0801041517h17a89b5ew28ee05ada7a76718@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> I think select pg_backend_pid(); will do that.

Perfect. I tried googling but I didn't try \df *pid* which would have found it

I tried to figure out the pg_stat_activity, but I can't think of a
WHERE condition that would make it give me the info I wanted.

Thx again to everyone.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2008-01-05 00:38:31 large table vacuum issues
Previous Message Colin Wetherbee 2008-01-04 23:11:02 Re: Getting process id of a connection?