Re: querying table structure/definition

From: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: querying table structure/definition
Date: 2000-09-25 22:20:47
Message-ID: 20000925182047.B10239@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michelle Murrain 2000-09-25 22:31:10 Re: DBD::Pg installation
Previous Message Neil Conway 2000-09-25 22:16:14 Re: DBD::Pg installation