Temporary schemas - Mailing list pgsql-general

From Thomas Kellerer
Subject Temporary schemas
Date
Msg-id iam5r0$2ko$1@dough.gmane.org
Whole thread Raw
Responses Re: Temporary schemas  (Thom Brown <thom@linux.com>)
Re: Temporary schemas  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Hello,

I have created a temporary table using

create temporary table foo
(
   id integer
);

and noticed this was created in a schema called "pg_temp_2"

My question is:

is this always "pg_temp_2"?
Or will the name of the "temp schema" change?

If it isn't always the same, is there a way I can retrieve the schema name for temporary tables?

Regards
Thomas

pgsql-general by date:

Previous
From: Alexander Farber
Date:
Subject: async queries in Perl and poll()/select() loop - how to make them work together?
Next
From: Fujii Masao
Date:
Subject: Re: Failover on Windows