Re: Temporary schemas

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Temporary schemas
Date: 2010-11-01 11:38:48
Message-ID: iam8s5$f1g$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Norberto Delle 2010-11-01 11:59:31 Re: Failover on Windows
Previous Message Thom Brown 2010-11-01 11:33:44 Re: Temporary schemas