Re: display temp table structure? - Mailing list pgsql-general

From Richard Huxton
Subject Re: display temp table structure?
Date
Msg-id 3AADD39F.E2DA7050@archonet.com
Whole thread Raw
In response to Re: display temp table structure?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: display temp table structure?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Re: Anyone can create tables!
Next
From: Richard Huxton
Date:
Subject: Re: help with simple rule