From: | "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: DESC |
Date: | 2000-11-22 17:38:15 |
Message-ID: | 20001122183815.A4363@frithjof |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(at)tph(dot)tuwien(dot)ac(dot)at>
Deutsch * English * Esperanto * Latine
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Beth K. Gatewood | 2000-11-22 18:30:37 | NOTICE: Unrecognized variable client_encoding |
Previous Message | Paul M Foster | 2000-11-22 01:01:27 | Re: DESC |