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

Поиск
Список
Период
Сортировка
От Jens Wilke
Тема Re: How to get schema name in which TEMPORARY table is created?
Дата
Msg-id 201103081518.34461.jens.wilke@affinitas.de
обсуждение исходный текст
Ответ на How to get schema name in which TEMPORARY table is created?  ("Gnanakumar" <gnanam@zoniac.com>)
Список pgsql-admin
Дерево обсуждения 
On Tuesday 08 March 2011 15:02:57 Gnanakumar wrote:

Hi,

> How do I get the schema name in which TEMPORARY table is created using
> "CREATE TEMP TABLE mytable ...." syntax?

select n.nspname from pg_class c join pg_namespace n on n.oid=c.relnamespace
where c.relname ='foo' and n.nspname like 'pg_temp%';

Regards Jens

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

Предыдущее
От: "Gnanakumar"
Дата:
Сообщение: How to get schema name in which TEMPORARY table is created?
Следующее
От: "Gnanakumar"
Дата:
Сообщение: Re: How to get schema name in which TEMPORARY table is created?