Re: DESC - Mailing list pgsql-novice

From Albert REINER
Subject Re: DESC
Date
Msg-id 20001122183815.A4363@frithjof
Whole thread Raw
In response to Re: DESC  (Paul M Foster <paulf@quillandmouse.com>)
Responses Re: DESC  (Mike Castle <dalgoda@ix.netcom.com>)
List pgsql-novice
On Tue, Nov 21, 2000 at 08:01:27PM -0500, Paul M Foster wrote:
> On Tue, Nov 21, 2000 at 12:58:44PM -0600, Mike Castle wrote:
...
> > Is there an equivalent for the SQL command DESC for listing the columns
> > and their various types?  (I've played around with Oracle's sqlplus stuff
> > a very little bit and this is command existed there and from I've seen
> > so far, should be an ANSI standard.)
...
> If I understand you correctly, the only thing I know of is available in
> the psql front end. It is the \d command, as in:
>
> \d mytable

And if you start psql with option -E you will see the actual
SQL-queries used by \d.

A.

--

--------------------------------------------------------------------------
Albert Reiner                                   <areiner@tph.tuwien.ac.at>
Deutsch       *       English       *       Esperanto       *       Latine
--------------------------------------------------------------------------

pgsql-novice by date:

Previous
From: Paul M Foster
Date:
Subject: Re: DESC
Next
From: "Beth K. Gatewood"
Date:
Subject: NOTICE: Unrecognized variable client_encoding