Re: DESC

From: Paul M Foster <paulf(at)quillandmouse(dot)com>
To: Mike Castle <dalgoda(at)ix(dot)netcom(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: DESC
Date: 2000-11-22 01:01:27
Message-ID: 20001121200127.H15934@quillandmouse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • DESC at 2000-11-21 18:58:44 from Mike Castle

Responses

  • Re: DESC at 2000-11-22 17:38:15 from Albert REINER

Browse pgsql-novice by date

  From Date Subject
Next Message Albert REINER 2000-11-22 17:38:15 Re: DESC
Previous Message Rynell Wesson 2000-11-21 23:28:06 Re: DESC