Re: DESC
Albert REINER <areiner@tph.tuwien.ac.at>
From: "Albert REINER" <areiner@tph.tuwien.ac.at>
To: pgsql-novice@postgresql.org
Date: 2000-11-22T17:38:15Z
Lists: 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 --------------------------------------------------------------------------