Re: Temporary schemas

On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
> 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?

Curious why you'd want to do this -- temporary magic schemas are an
implementation artifact, and there shouldn't ever be a reason to
directly reference them.

merlin