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: | Pine.LNX.4.21.0011211722200.18302-100000@isle-of-jura.cs.utexas.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
Thanks.
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 (http://www.postgresql.org/gen-info.html) 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
> www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc
> We are all of us living in the shadow of Manhattan. -- Watchmen
>
From | Date | Subject | |
---|---|---|---|
Next Message | Paul M Foster | 2000-11-22 01:01:27 | Re: DESC |
Previous Message | jacques | 2000-11-21 19:36:45 | Re: createdb ok, but need more help |