I think I might have described this wrong- "\dt" works the same in
version 6 and 7. However "\d *" shows you the detail of **each** table
in the database. So if you two tables called "status" and "tasks", the
output of "\d *" would be:
Table = status
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| statid | int4
| 4 |
| flag | varchar()
| 80 |
| color | char()
| 6 |
+----------------------------------+----------------------------------+-------+
Table = tasks
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| taskid | int4
| 4 |
| jid | int4
| 4 |
| conid | int4
| 4 |
| workdone | varchar()
| 800 |
| date | char()
| 10 |
+----------------------------------+----------------------------------+-------+
if these were the only tables in the database. Since version 7 of pgSQL
doesn't seem to support this, I would like to know what is the
alternative way to list all of the tables AND their field descriptions?
Thanks
cwz wrote:
> use \dt
>
> Note:
> \d{t|i|s|v} list tables/indices/sequences/views
> \d{p|S|l} list permissions/system tables/lobjects
> \da list aggregates
> \dd [object] list comment for table, type, function, or operator
> \df list functions
> \do list operators
> \dT list data types
>
> Curt