Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 4CC971337BDD
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  8 Mar 2011 10:28:42 -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 26308-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  8 Mar 2011 14:28:35 +0000 (UTC)
X-Greylist: delayed 00:08:25.227887 by SQLgrey-1.7.6
Received: from mail.affinitas.de (mail.affinitas.de [91.102.12.84])
	by mail.postgresql.org (Postfix) with ESMTP id 0522E1337BCE
	for <pgsql-admin@postgresql.org>; Tue,  8 Mar 2011 10:28:34 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by mail.affinitas.de (Postfix) with ESMTP id 68F20246A022
	for <pgsql-admin@postgresql.org>; Tue,  8 Mar 2011 15:20:08 +0100 (CET)
X-Virus-Scanned: Debian amavisd-new at mail.affinitas.de
Received: from mail.affinitas.de ([127.0.0.1])
	by localhost (mail.affinitas.de [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id AqLX0uHEFQIm for <pgsql-admin@postgresql.org>;
	Tue,  8 Mar 2011 15:20:08 +0100 (CET)
Received: from affinitas180.localnet (unknown [91.102.12.2])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by mail.affinitas.de (Postfix) with ESMTPSA
	for <pgsql-admin@postgresql.org>; Tue,  8 Mar 2011 15:20:08 +0100 (CET)
From: Jens Wilke <jens.wilke@affinitas.de>
Organization: Affinitas GmbH
To: pgsql-admin@postgresql.org
Subject: Re: How to get schema name in which TEMPORARY table is created?
Date: Tue, 8 Mar 2011 15:18:34 +0100
User-Agent: KMail/1.13.5 (Linux/2.6.32-5-amd64; KDE/4.4.5; x86_64; ; )
References: <005201cbdd99$8930e990$9b92bcb0$@com>
In-Reply-To: <005201cbdd99$8930e990$9b92bcb0$@com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <201103081518.34461.jens.wilke@affinitas.de>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201103/87
X-Sequence-Number: 36959

On Tuesday 08 March 2011 15:02:57 Gnanakumar wrote:

Hi,

> How do I get the schema name in which TEMPORARY table is created using
> "CREATE TEMP TABLE mytable ...." syntax?

select n.nspname from pg_class c join pg_namespace n on n.oid=c.relnamespace 
where c.relname ='foo' and n.nspname like 'pg_temp%';

Regards Jens