Re: DESC

On Tue, Nov 21, 2000 at 12:58:44PM -0600, Mike Castle wrote:

>
> Not just a pgsql novice, but an SQL novice in general.
>
> 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

Else I know of nothing. Unfortunately.

Paul