From: | "Andrew G(dot) Hammond" <drew(at)xyzzy(dot)dhs(dot)org> |
---|---|
To: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
Cc: | "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is there a PostgresQL equivalent to the DESCRIBE |
Date: | 2001-12-18 22:39:31 |
Message-ID: | 1008715173.861.4.camel@xyzzy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If you want to see the SQL that psql uses to do this, \set ECHO_HIDDEN
or start psql with the -E option.
On Fri, 2001-12-14 at 19:09, Andrew Gould wrote:
> In psql, enter \d [table name].
>
> Best of luck,
>
> Andrew Gould
>
> --- "Peter E. Chen" <pchen3(at)jhmi(dot)edu> wrote:
> > Hey All,
> >
> > I'm trying to display the schema to various tables.
> > In most other
> > databases, you can use the DESCRIBE keyword or the
> > SHOW keyword (I believe
> > this is a SQL99 keyword). Is there an equivalent in
> > PostgresQL?
> >
> > Also, does PostgresQL have an equivalent to the
> > following:
> >
> > SHOW CREATE TABLE table_name
> >
> > Thanks for any help.
> >
> > Peter
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
>
>
> __________________________________________________
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for all of
> your unique holiday gifts! Buy at http://shopping.yahoo.com
> or bid at http://auctions.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
--
Andrew G. Hammond mailto:drew(at)xyzzy(dot)dhs(dot)org
http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F
613-389-5481
5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Harding | 2001-12-18 22:44:19 | Re: More on Too Many Open Files... NetBSD |
Previous Message | Doug McNaught | 2001-12-18 22:31:10 | Re: More on Too Many Open Files... NetBSD |