Re: Temporary schemas

[Thomas Kellerer <spam_eater@xxxxxxx>]

Thom Brown wrote on 01.11.2010 12:33:
> You can use:
>
> SELECT nspname
> FROM pg_namespace
> WHERE oid = pg_my_temp_schema();
>
> to get the name of the current temporary schema for your session.

Thanks that's what I was looking for.

Regards
Thomas

 


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general