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

Поиск
Список
Период
Сортировка
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 по дате отправления:

Предыдущее
От: Bob Lunney
Дата:
Сообщение: Re: PG Server Crash
Следующее
От: Jens Wilke
Дата:
Сообщение: Re: How to get schema name in which TEMPORARY table is created?