Aggregate function capability with \d in psql

Поиск
Список
Период
Сортировка
От Pascal Polleunus
Тема Aggregate function capability with \d in psql
Дата
Msg-id 404756E6.60205@beeznest.net
обсуждение исходный текст
Ответы Re: Aggregate function capability with \d in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

Is there an *easy* way to display a list of tables with their number of
input values in psql ?

Wouldn't it be useful to have the ability to execute aggregate functions
with the \d command ?

Currently (psql 7.4.1):
   \d [NAME]      describe table, index, sequence, or view
   \d{t|i|s|v|S} [PATTERN] (add "+" for more detail)
                  list tables/indexes/sequences/views/system tables

Adding for example:
   \d{t|S|v} [PATTERN] [-exec COMMAND] (add "+" for more detail)
                  list tables/views/system tables
                  with the result of the aggregate command

And extending the concept to:
   \ds [PATTERN] [-exec {curr|next|min|max}]


Thanks,
Pascal


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

Предыдущее
От: "Karl O. Pinc"
Дата:
Сообщение: Re: REFERENCES error message complaint, suggestion
Следующее
От: Tom Lane
Дата:
Сообщение: Re: REFERENCES error message complaint, suggestion