Re: What constitutes a pgsql session?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Taber, Mark" <Mark(dot)Taber(at)dof(dot)ca(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: What constitutes a pgsql session?
Date: 2004-08-11 01:44:46
Message-ID: 200408110144.i7B1ikB04309@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mike G 2004-08-11 04:11:15 Re: Script done.
Previous Message Ron St-Pierre 2004-08-10 23:16:33 Re: DISTINCT ordering