Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get schema name in which TEMPORARY table is created? - Mailing list pgsql-admin

From Christian Ullrich
Subject Re: How to get schema name in which TEMPORARY table is created?
Date
Msg-id il7g0n$r4j$1@dough.gmane.org
Whole thread Raw
In response to How to get schema name in which TEMPORARY table is created?  ("Gnanakumar" <gnanam@zoniac.com>)
List pgsql-admin
Tree view 
* Gnanakumar wrote:

> We're using PostgreSQL v8.2.3.
>
> How do I get the schema name in which TEMPORARY table is created using
> "CREATE TEMP TABLE mytable ...." syntax?

SELECT nspname FROM pg_namespace WHERE oid = pg_my_temp_schema();

I don't have an 8.2.3 lying around, but git says that function is in there.

pgsql-admin by date:

Previous
From: "Gnanakumar"
Date:
Subject: Re: How to get schema name in which TEMPORARY table is created?
Next
From: "Gnanakumar"
Date:
Subject: Advise on dropping TEMP table/schema for my use case