Skip site navigation (1) Skip section navigation (2)


From: Mike Castle <dalgoda(at)ix(dot)netcom(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: DESC
Date: 2000-11-22 18:54:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Wed, Nov 22, 2000 at 06:38:15PM +0100, Albert REINER wrote:
> And if you start psql with option -E you will see the actual
> SQL-queries used by \d.

That's nifty.  I've read through all of the pgsql documentation before
starting everything, but I think I'm suffering a bit from information
overload.  I knew this information was somewhere, I just couldn't remember

So, thanks to all who pointed me to \d.

Ok then.  It looks to me like both "DESC" and "DESCRIBE" are SQL keywords.
DESC apparently is meant for descending, so I'm guessing that Oracle's
sqlplus usage of DESC is an extension.  Is that correct?

If so, is "DESCRIBE" the ANSI command that should do what \d does or does
it serve another purpose in ANSI?  (A pointer as to where to find this
explicitly would be nice; will eventually purchase the standard myself).

If DESCRIBE is supposed to do that, is there any reason that pgsql doesn't
do that outside of "\d works, so no one has bothered to implement it."

       Mike Castle       Life is like a clock:  You can work constantly
  dalgoda(at)ix(dot)netcom(dot)com  and be right all the time, or not work at all and be right at least twice a day.  -- mrc
    We are all of us living in the shadow of Manhattan.  -- Watchmen

In response to

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


  • Re: DESC at 2000-11-22 19:01:10 from D. Duccini
  • Re: DESC at 2000-11-22 19:16:53 from Tom Lane
  • Re: DESC at 2000-11-22 22:51:28 from Rynell Wesson

pgsql-novice by date

Next:From: D. DucciniDate: 2000-11-22 19:01:10
Subject: Re: DESC
Previous:From: Beth K. GatewoodDate: 2000-11-22 18:30:37
Subject: NOTICE: Unrecognized variable client_encoding

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group