By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,993 Members | 1,883 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,993 IT Pros & Developers. It's quick & easy.

Aggregate function capability with \d in psql

P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Pascal Polleunus <pp*@beeznest.net> writes:
Wouldn't it be useful to have the ability to execute aggregate functions
with the \d command ?


Use the information_schema if you want to write queries about this
information.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.