Re: What constitutes a pgsql session? - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: What constitutes a pgsql session?
Date
Msg-id 200408110144.i7B1ikB04309@candle.pha.pa.us
Whole thread Raw
In response to What constitutes a pgsql session?  ("Taber, Mark" <Mark.Taber@dof.ca.gov>)
Responses Re: What constitutes a pgsql session?
List pgsql-novice
Taber, Mark wrote:
> We have a need to create temporary tables (within functions); the
> documentation states that temporary tables last as long as the pg session.
> What, precisely, does this mean?  The length of the active connection?

Yes, a session is the client/server db connection.  When you disconnect,
the session is terminated.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-novice by date:

Previous
From: Christian Poecher
Date:
Subject: Re: Query result to a file
Next
From: Mike G
Date:
Subject: Re: Script done.