Re: \d+ for long view definitions?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: \d+ for long view definitions?
Дата
Msg-id 2170.1251672231@sss.pgh.pa.us
обсуждение исходный текст
Ответ на \d+ for long view definitions?  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: \d+ for long view definitions?  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: \d+ for long view definitions?  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Using \d on, say, information schema views is completely hilarious
> because the column name/data type information is usually scrolled off
> the screen by the immense view definition.

> Could we change this perhaps so that the full view definition is only
> shown with \d+ when the view definition is longer than N characters or N
> lines or some other suitable cutoff.  Ideas?

The same complaint could be made for any table with more than
twenty-some columns.  Seems like a more general answer would be
for \d output to go through the pager ...
        regards, tom lane


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: \d+ for long view definitions?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: \d+ for long view definitions?