Re: querying table structure/definition - Mailing list pgsql-general

From Neil Conway
Subject Re: querying table structure/definition
Date
Msg-id 20000925182047.B10239@klamath.dyndns.org
Whole thread Raw
In response to querying table structure/definition  (Andrew Gould <andrewgould@yahoo.com>)
List pgsql-general
On Mon, Sep 25, 2000 at 01:54:09PM -0700, Andrew Gould wrote:
> What psql or sql commands can be used to view the
> structure of a table?

Using psql, try:

    \d table_name

For more psql commands, look at the output of '\?' from inside psql.

HTH,

Neil

--
Neil Conway <neilconway@home.com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

Vegetarians do not love animals... they hate plants.

Attachment

pgsql-general by date:

Previous
From: Michelle Murrain
Date:
Subject: Re: DBD::Pg installation
Next
From: Tim Kientzle
Date:
Subject: more or less spontaneous reboots with Suse 6.4 / Postgresql 7.0.2