Re: Getting process id of a connection? - Mailing list pgsql-general

From Webb Sprague
Subject Re: Getting process id of a connection?
Date
Msg-id b11ea23c0801041517h17a89b5ew28ee05ada7a76718@mail.gmail.com
Whole thread Raw
In response to Re: Getting process id of a connection?  (Bricklen Anderson <banderson@presinet.com>)
List 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.

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [OT] Slony (initial) Replication - Slow
Next
From: "Ken Winter"
Date:
Subject: Re: Problem with pg_dump?