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


From: Rynell Wesson <rwesson(at)cs(dot)utexas(dot)edu>
To: Mike Castle <dalgoda(at)ix(dot)netcom(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: DESC
Date: 2000-11-21 23:28:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Start a psql session on the db you want and type \d <table name> and this
will describe the table for you.  You should also type \? for more options
under psql.


Rynell Wesson

On Tue, 21 Nov 2000, 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.)
> I looked through the email archives and didn't see anything.
> Oh, dear.  I just went to check again, and off of the User's Lounge, the
> General Information link ( just
> gave me a 404 error.  Someone reorganizing?
> Anyway, I've pondered writing such a thing, and decided to look at how
> pg_dump figures things out and quickly decided to ask first.
> Thanks,
> mrc
> -- 
>        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

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

pgsql-novice by date

Next:From: Paul M FosterDate: 2000-11-22 01:01:27
Subject: Re: DESC
Previous:From: jacquesDate: 2000-11-21 19:36:45
Subject: Re: createdb ok, but need more help

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