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 8585CD1E669
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 23:29:53 +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 09196-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 19:29:25 -0400 (AST)
Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222])
	by svr1.postgresql.org (Postfix) with ESMTP id 106F6D1E61F
	for <pgsql-sql@postgresql.org>; Fri,  9 Jan 2004 19:29:18 -0400 (AST)
Received: from css120.ihs.com (css120.ihs.com [170.207.105.120])
	by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i09NRxPJ011478;
	Fri, 9 Jan 2004 16:27:59 -0700 (MST)
Date: Fri, 9 Jan 2004 16:10:23 -0700 (MST)
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Bing Du <bdu@iastate.edu>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: how to show table structure?
In-Reply-To: <2094.129.186.197.127.1073689537.squirrel@mail.eng.iastate.edu>
Message-ID: <Pine.LNX.4.33.0401091608580.6872-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-IHS-MailScanner: Found to be clean
X-IHS-MailScanner-SpamCheck: 
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/77
X-Sequence-Number: 16470

On Fri, 9 Jan 2004, Bing Du 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.

If in psql, use the \d commands (\? will show you all of them.

However, if you've not got psql to do it, you can look through the 
information_schema for anything like that, like so:

select * from information_schema.tables;

and so on.