If you want a graphical approach, try pgaccess for X interface. Its very
clean in displaying tables
Keith C. Perry wrote in message <3A790EDC.8D9B7D22@vcsn.com>...
>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
