Обсуждение: How do I list all tables?

In 6.4.2 the "\?" output while in psql says that you can do "\d *" to
list all of the tables in a particular database.  In 7.0.3, this is NOT
mentioned and the same syntax does NOT work.  Is there another way to
mimic the results of this statement in 6.4.2?  Thanks!

Keith C. Perry
http://vcsn.com

In article <3A785CBD.542F1948@vcsn.com>, "Keith Perry" <keith@vcsn.com>
wrote:

> In 6.4.2 the "\?" output while in psql says that you can do "\d *" to
> list all of the tables in a particular database.  In 7.0.3, this is NOT

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

On Wed, 31 Jan 2001, Keith Perry wrote:

> In 6.4.2 the "\?" output while in psql says that you can do "\d *" to
> list all of the tables in a particular database.  In 7.0.3, this is NOT
> mentioned and the same syntax does NOT work.  Is there another way to
> mimic the results of this statement in 6.4.2?  Thanks!

\d with no arguments will list all tables.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
The human mind treats a new idea the way the body treats a strange
protein -- it rejects it.
        -- P. Medawar