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 24422D1E457
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 23:06:11 +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 02092-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 19:05:42 -0400 (AST)
Received: from mailhub-3.iastate.edu (mailhub-3.iastate.edu [129.186.140.13])
	by svr1.postgresql.org (Postfix) with ESMTP id 05BA3D1E5B7
	for <pgsql-sql@postgresql.org>; Fri,  9 Jan 2004 19:05:37 -0400 (AST)
Received: from mailout-1.iastate.edu (mailout-1.iastate.edu [129.186.140.1])
	by mailhub-3.iastate.edu (8.12.10/8.12.10) with SMTP id i09N5avn031158
	for <pgsql-sql@postgresql.org>; Fri, 9 Jan 2004 17:05:37 -0600
Received: from indian.eng.iastate.edu(129.186.23.14) by mailout-1.iastate.edu
	via csmap id 92d7f36e_42f8_11d8_990c_003048290bef_3598;
	Fri, 09 Jan 2004 17:07:19 -0600 (CST)
Received: from 129.186.197.127 (SquirrelMail authenticated user bdu)
	by mail.eng.iastate.edu with HTTP;
	Fri, 9 Jan 2004 17:05:37 -0600 (CST)
Message-ID: <2094.129.186.197.127.1073689537.squirrel@mail.eng.iastate.edu>
Date: Fri, 9 Jan 2004 17:05:37 -0600 (CST)
Subject: how to show table structure?
From: "Bing Du" <bdu@iastate.edu>
To: pgsql-sql@postgresql.org
User-Agent: SquirrelMail/1.4.2-1
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3
Importance: Normal
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/75
X-Sequence-Number: 16468

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.

Thanks in advance for any help.

Bing