Обсуждение: Re: How do I list all tables?
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
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