How to get schema name in which TEMPORARY table is created? - Mailing list pgsql-admin

From Gnanakumar
Subject How to get schema name in which TEMPORARY table is created?
Date
Msg-id 005201cbdd99$8930e990$9b92bcb0$@com
Whole thread Raw
Responses Re: How to get schema name in which TEMPORARY table is created?  (Jens Wilke <jens.wilke@affinitas.de>)
Re: How to get schema name in which TEMPORARY table is created?  ("Gnanakumar" <gnanam@zoniac.com>)
Re: How to get schema name in which TEMPORARY table is created?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How to get schema name in which TEMPORARY table is created?  (Christian Ullrich <chris@chrullrich.net>)
List 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


pgsql-admin by date:

Previous
From: Bob Lunney
Date:
Subject: Re: PG Server Crash
Next
From: Jens Wilke
Date:
Subject: Re: How to get schema name in which TEMPORARY table is created?