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

Поиск
Список
Период
Сортировка
От Christian Ullrich
Тема Re: How to get schema name in which TEMPORARY table is created?
Дата
Msg-id il7g0n$r4j$1@dough.gmane.org
обсуждение исходный текст
Ответ на How to get schema name in which TEMPORARY table is created?  ("Gnanakumar" <gnanam@zoniac.com>)
Список pgsql-admin
Дерево обсуждения 
* Gnanakumar wrote:

> 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?

SELECT nspname FROM pg_namespace WHERE oid = pg_my_temp_schema();

I don't have an 8.2.3 lying around, but git says that function is in there.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Gnanakumar"
Дата:
Сообщение: Re: How to get schema name in which TEMPORARY table is created?
Следующее
От: "Gnanakumar"
Дата:
Сообщение: Advise on dropping TEMP table/schema for my use case