Re: [SQL] how to show table structure?

[Larry Rosenman]

--On Friday, January 09, 2004 17:05:37 -0600 Bing Du <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgp00000.pgp
Description: PGP signature