Re: display temp table structure?

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