Re: [GENERAL] Temporary tables and miscellaneous schemas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Temporary tables and miscellaneous schemas
Дата
Msg-id 18789.1072132914@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Temporary tables and miscellaneous schemas  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [GENERAL] Temporary tables and miscellaneous schemas
Список pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Is current_schemas(true))[1] always the temp schema name?

If you have a temp schema; otherwise it'll be whatever is the front of
your search path.

> That would clean things up nicely.

If you're intent on doing this in \dn, something like

... AND (nspname not like 'pg\\_temp%'
         OR nspname = (current_schemas(true))[1]) ...

would probably work well enough.

            regards, tom lane

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

Предыдущее
От: David Fetter
Дата:
Сообщение: Doc patch--clarifying $1 in PL/PgSQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Doc patch--clarifying $1 in PL/PgSQL