Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B0E84133798E for ; Wed, 9 Mar 2011 00:46:52 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 70241-05 for ; Wed, 9 Mar 2011 04:46:45 +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 DCF0D1336FA7 for ; Wed, 9 Mar 2011 00:46:44 -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 p294kedH013994; Tue, 8 Mar 2011 22:46:42 -0600 Reply-To: From: "Gnanakumar" To: "'Tom Lane'" Cc: References: <005201cbdd99$8930e990$9b92bcb0$@com> <9914.1299598796@sss.pgh.pa.us> In-Reply-To: <9914.1299598796@sss.pgh.pa.us> Subject: Re: How to get schema name in which TEMPORARY table is created? Date: Wed, 9 Mar 2011 10:13:01 +0530 Organization: Zoniac Software Private Limited Message-ID: <001c01cbde14$7ac51680$704f4380$@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: AcvdpxTkquwbrI/DRk2HyShzk37zqwAbRJCQ Content-Language: en-us 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/91 X-Sequence-Number: 36963 >> How do I get the schema name in which TEMPORARY table is created using >> "CREATE TEMP TABLE mytable ...." syntax? > Do you need the real schema name, or will the "pg_temp" alias be > sufficient? I need the real schema name (for example, pg_temp_xxx) in which it is created and not just the alias.