Re: Temporary tables and miscellaneous schemas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Temporary tables and miscellaneous schemas
Дата
Msg-id 12470.1067289295@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Temporary tables and miscellaneous schemas  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Temporary tables and miscellaneous schemas  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> How about if we add a UNION that does:
>     UNION
>     SELECT 'non-local temp schemas skipped', NULL

I think showing that would only be appropriate if we actually *did* skip
some.  Finding that out would complicate the query unduly IMHO.

> I see a few goals here:
>     Prevent \dn from showing lots of lines for large installs
>     Show the local temp schema so people can query it

If those are agreed to be the goals then we end up with your original
solution (or a working implementation of same anyway).

I'd like to see some input from other people about what they want...

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Temporary tables and miscellaneous schemas
Следующее
От: Sean Chittenden
Дата:
Сообщение: Re: Temporary tables and miscellaneous schemas