Aggregate function capability with \d in psql

From: Pascal Polleunus <ppo(at)beeznest(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Aggregate function capability with \d in psql
Date: 2004-03-04 16:18:46
Message-ID: 404756E6.60205@beeznest.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-03-04 16:24:11 Re: REFERENCES error message complaint, suggestion
Previous Message Karl O. Pinc 2004-03-04 16:17:03 Re: REFERENCES error message complaint, suggestion