Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 841B7133740B
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  8 Mar 2011 10:06:50 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 37832-08 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  8 Mar 2011 14:06:39 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from rs73.luxsci.com (rs73.luxsci.com [64.49.254.135])
	by mail.postgresql.org (Postfix) with ESMTP id 4E2BD133616B
	for <pgsql-admin@postgresql.org>; Tue,  8 Mar 2011 10:06:38 -0400 (AST)
Received: from GNANAM ([180.151.61.10]) (authenticated bits=0)
	by rs73.luxsci.com (8.13.8/8.13.8) with ESMTP id p28E6at6012407;
	Tue, 8 Mar 2011 08:06:37 -0600
Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: <pgsql-admin@postgresql.org>
Subject: How to get schema name in which TEMPORARY table is created?
Date: Tue, 8 Mar 2011 19:32:57 +0530
Organization: Zoniac Software Private Limited
Message-ID: <005201cbdd99$8930e990$9b92bcb0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcvdmYKMzbMBxiW4Qk+lhUKg+CzWvg==
Content-Language: en-us
x-cr-hashedpuzzle: PQk= RXc= BePY Bo2n B/He C3L9 C+ig DZZj DgCh FTl5 GxVA HHYk
	Hcw9 Hw7q H1Mi JNzj; 1;
	cABnAHMAcQBsAC0AYQBkAG0AaQBuAEAAcABvAHMAdABnAHIAZQBzAHEAbAAuAG8AcgBnAA==;
	Sosha1_v1; 7; {8704047D-2484-4250-A8E2-D40BC4A191BB};
	ZwBuAGEAbgBhAG0AQAB6AG8AbgBpAGEAYwAuAGMAbwBtAA==;
	Tue, 08 Mar 2011 14:02:50 GMT;
	SABvAHcAIAB0AG8AIABnAGUAdAAgAHMAYwBoAGUAbQBhACAAbgBhAG0AZQAgAGkAbgAgAHcAaABpAGMAaAAgAFQARQBNAFAATwBSAEEAUgBZACAAdABhAGIAbABlACAAaQBzACAAYwByAGUAYQB0AGUAZAA/AA==
x-cr-puzzleid: {8704047D-2484-4250-A8E2-D40BC4A191BB}
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201103/86
X-Sequence-Number: 36958

Hi,

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?

In our application, we're creating temporary table with the same as an
existing permanent table which is available in "public" schema.  Hence, I
want to find out the schema name in which temporary tables are getting
created.

Regards,
Gnanam