How to get schema name in which TEMPORARY table is created?

From: "Gnanakumar" <gnanam(at)zoniac(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How to get schema name in which TEMPORARY table is created?
Date: 2011-03-08 14:02:57
Message-ID: 005201cbdd99$8930e990$9b92bcb0$@com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jens Wilke 2011-03-08 14:18:34 Re: How to get schema name in which TEMPORARY table is created?
Previous Message Heikki Linnakangas 2011-03-08 08:55:38 Re: Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum