Global temporary table - schema - Mailing list pgsql-general

From Ravi Katkar
Subject Global temporary table - schema
Date
Msg-id 46AC8D44F3AE1F4888F137837D0DF63507256199C5@INHYWEXMB2.infor.com
Whole thread Raw
In response to disable password prompt - command line  (Ravi Katkar <Ravi.Katkar@infor.com>)
Responses Re: Global temporary table - schema
List pgsql-general

Hi List,

 

When I have created Global temporary table its created under/in PG_temp_1 schema by default,

When tried to specify the schema name explicitly its throwing below error

 

ERROR:  temporary tables cannot specify a schema name

 

I wanted to create a Global temporary table in public or the schema I wish.

 

Any ideas?

 

Thanks in advance.

 

 

-- Ravi Katkar

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: No PL/PHP ? Any reason?
Next
From: Pavel Stehule
Date:
Subject: Re: Global temporary table - schema