Re: how to show table structure?

--On Friday, January 09, 2004 17:05:37 -0600 Bing Du <bdu(at)iastate(dot)edu>
wrote:

> Greetings,
>
> How can I see the layout of a table in PostgreSQL 7.4? I've checked
> several books and on-line documents, but was not able to figure out how
> PostgreSQL does 'describe <table>' like it's done in other databases.
\d table

in psql.

LER

>
> Thanks in advance for any help.
>
> Bing
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749