On Mon, Nov 1, 2010 at 6:46 AM, Thomas Kellerer <spam_ea...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
