How to get schema name in which TEMPORARY table is created? - Mailing 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?