Re: problem trying to create a temp table - Mailing list pgsql-general

From Richard Huxton
Subject Re: problem trying to create a temp table
Date
Msg-id 4F479523.1080606@archonet.com
Whole thread Raw
In response to Re: problem trying to create a temp table  (Andrew Gould <andrewlylegould@gmail.com>)
List pgsql-general
On 24/02/12 13:37, Andrew Gould wrote:
> On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton<dev@archonet.com>  wrote:
>>
>> Temp tables get their own schema, and each session (connection) gets
>> its own temp schema. So - don't qualify them by schema.
>
> Is that to avoid naming conflicts between simultaneous users?

Yes. I believe it also invisibly adds it to your search_path too, the
same as it does with the pg_catalog schema.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: problem trying to create a temp table
Next
From: Vick Khera
Date:
Subject: Re: Configuring for very slow I/O