From: Gnanakumar <gnanam@zoniac.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to get schema name in which TEMPORARY table is created?
Date: Wed, 9 Mar 2011 10:13:01 +0530
Message-ID: <001c01cbde14$7ac51680$704f4380$@com> (raw)
In-Reply-To: <9914.1299598796@sss.pgh.pa.us>
References: <005201cbdd99$8930e990$9b92bcb0$@com>
<9914.1299598796@sss.pgh.pa.us>
>> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gnanam@zoniac.com, tgl@sss.pgh.pa.us
Subject: Re: How to get schema name in which TEMPORARY table is created?
In-Reply-To: <001c01cbde14$7ac51680$704f4380$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox