Re: DESC - Mailing list pgsql-novice

From Paul M Foster
Subject Re: DESC
Date
Msg-id 20001121200127.H15934@quillandmouse.com
Whole thread Raw
In response to DESC  (Mike Castle <dalgoda@ix.netcom.com>)
Responses Re: DESC  ("Albert REINER" <areiner@tph.tuwien.ac.at>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Rynell Wesson
Date:
Subject: Re: DESC
Next
From: "Albert REINER"
Date:
Subject: Re: DESC