Re: Viewing non-system objects in psql

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Viewing non-system objects in psql
Дата
Msg-id 20050617023149.GB10795@fetter.org
обсуждение исходный текст
Ответ на Viewing non-system objects in psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Viewing non-system objects in psql  (Doug Bloebaum <blabes@gmail.com>)
Список pgsql-general
On Thu, Jun 16, 2005 at 07:54:29PM -0000, Greg Sabino Mullane wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I recently submitted a patch that makes all the database objects
> behave in the same way as far as the backslash psql commands.
> Currently, tables work like this: \dt lists all non-system tables in
> your path, while \dtS shows only the system tables. The idea is to
> expand that functionality to other database objects, e.g. functions.
> Currently, \df will show you a list of *all* functions, including
> the system ones. Since there are currently over 1500 system
> functions, this limits its usefullness. The patch standardizes
> everything on the way we do tables and indexes - the user ones are
> shown by default, and you add a capital "S" if you really want to
> see the system ones. So the patch would have \df show all your
> functions, \dD show all your domains, \doS shows the system
> operators, etc.

+1 :)

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

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

Предыдущее
От: David Pratt
Дата:
Сообщение: Advice on structure /sequence / trigger
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Advice on structure /sequence / trigger