Global temporary table - schema

[Ravi Katkar <Ravi.Katkar@xxxxxxxxx>]

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