Re: temp table question - Mailing list pgsql-general

From Scott Marlowe
Subject Re: temp table question
Date
Msg-id dcc563d10802012032t3fa56011t1aef9e9b21dccd66@mail.gmail.com
Whole thread Raw
In response to temp table question  (Kevin Kempter <kevin@kevinkempterllc.com>)
List pgsql-general
On Feb 1, 2008 9:06 PM, Kevin Kempter <kevin@kevinkempterllc.com> wrote:
> Hi list;
>
> If I create a temp table (i.e. create temp table xyz as select from ...) is
> the scope of this table limited to a session. Meaning,  can several sessions
> all run the above create temp table statement all referencing the same temp
> table name at the same time?

Temp tables are only visible to the session that created them.  See

http://www.postgresql.org/docs/8.2/interactive/sql-createtable.html

pgsql-general by date:

Previous
From: brian
Date:
Subject: Re: temp table question
Next
From: Ted Byers
Date:
Subject: Re: arrays of floating point numbers / linear algebra operations into the DB