Re: How do I list all tables?

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