Re: How do I list all tables?

From: "cwz" <curt-pgsql(at)onlinemusic(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How do I list all tables?
Date: 2001-01-31 09:08:41
Message-ID: 95a8rg$jb3$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <3A785CBD(dot)542F1948(at)vcsn(dot)com>, "Keith Perry" <keith(at)vcsn(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Orsinger 2001-01-31 09:25:40 Re: Write to postgreSQL via ODBC?
Previous Message Craig Orsinger 2001-01-31 09:08:04 Re: MS Excel to PostgreSQL?