Thread: How do I list all tables?

How do I list all tables?

From

Keith Perry

Date:

06 February 2001, 08:29:01

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

Re: How do I list all tables?

From

"cwz"

Date:

06 February 2001, 08:41:13

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

Re: How do I list all tables?

From

"Brett W. McCoy"

Date:

06 February 2001, 09:10:13

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