Tom Lane wrote:
>
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > There is no user-visible mapping, though the number is the process id.
> > You could use that. I think you can get the backend process id somehow,
> > but I am not sure how. Anyone?
>
> If you're using libpq, there is a function to retrieve the backend's PID
> from the PGconn (PQbackendPID). I don't think any of the other client
> libraries provide this (yet).
I installed getpid() as a user-defined function (while testing an idea)
- it seemed to work and I assumed it was the backend pid I was getting.
- Richard Huxton