X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 49CBDD1E62C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 23:13:00 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 06819-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 19:12:31 -0400 (AST)
Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11])
	by svr1.postgresql.org (Postfix) with ESMTP id 1ED49D1E61F
	for <pgsql-sql@postgresql.org>; Fri,  9 Jan 2004 19:12:24 -0400 (AST)
Received: from lerlaptop-red.iadfw.net ([207.136.3.72])
	by lerami.lerctr.org with asmtp (Exim 4.30)
	id 1Af5nW-0001Tn-9B; Fri, 09 Jan 2004 17:12:10 -0600
Date: Fri, 09 Jan 2004 17:12:09 -0600
From: Larry Rosenman <ler@lerctr.org>
To: Bing Du <bdu@iastate.edu>, pgsql-sql@postgresql.org
Subject: Re: how to show table structure?
Message-ID: <240370000.1073689929@lerlaptop-red.iadfw.net>
In-Reply-To: <2094.129.186.197.127.1073689537.squirrel@mail.eng.iastate.edu>
References: <2094.129.186.197.127.1073689537.squirrel@mail.eng.iastate.edu>
X-Mailer: Mulberry/3.1.0 (Linux/x86)
X-PGP-Info: All other keys are old/dead.
X-PGP-Key: 0x3c49bdd6
X-PGP-Fingerprint: D0D1 3C11 F42F 6B29 FA67  6BF3 AD13 4685 3C49 BDD6
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="==========8484C0DE58D50615A0E9=========="
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/76
X-Sequence-Number: 16469

--==========8484C0DE58D50615A0E9==========
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline



--On Friday, January 09, 2004 17:05:37 -0600 Bing Du <bdu@iastate.edu>=20
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@postgresql.org so that your
>       message can get through to the mailing list cleanly
>



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

--==========8484C0DE58D50615A0E9==========
Content-Type: application/pgp-signature
Content-Transfer-Encoding: 7bit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD4DBQE//zVJrRNGhTxJvdYRAvAYAJ4s6noH3caF3AgBhjxmMlX6ImI1mQCYrtcR
eljYg/uoDC6BdI7+S9oVkg==
=EbTj
-----END PGP SIGNATURE-----

--==========8484C0DE58D50615A0E9==========--