Re: Is there a PostgresQL equivalent to the DESCRIBE keyword???

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