Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id A035E475C81
	for <pgsql-sql@postgresql.org>; Wed, 15 May 2002 10:49:31 -0400 (EDT)
Received: from brasileiro.net (unknown [129.123.236.160])
	by postgresql.org (Postfix) with ESMTP id 0DB1B475C7D
	for <pgsql-sql@postgresql.org>; Wed, 15 May 2002 10:49:27 -0400 (EDT)
Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian))
	id 17805p-0004qA-00; Wed, 15 May 2002 08:49:29 -0600
Date: Wed, 15 May 2002 08:49:29 -0600
From: Roberto Mello <rmello@cc.usu.edu>
To: Ang Tun Chek <atchek@eware.com.my>
Cc: pgsql-sql@postgresql.org
Subject: Re: some questions
Message-ID: <20020515144929.GA18588@cc.usu.edu>
References: <3CE1E8DB.4000105@eware.com.my>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <3CE1E8DB.4000105@eware.com.my>
User-Agent: Mutt/1.3.28i
X-message-flag: Please consider using an e-mail program other than Outlook.
	It's insecure.
X-Archive-Number: 200205/158
X-Sequence-Number: 7794

On Wed, May 15, 2002 at 12:49:31PM +0800, Ang Tun Chek wrote:
> hi
>    i am new to postresql and i need some help for some sql command
> 
>    what is the sql command in postresql equal to "describe table"?
> 
>    what is the sql command to list all tables in the database?

Following up on what has already been said, try also "\?" in psql. Also
read the documentation for psql and the User's Guide.

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ 
       http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    
Ex astra, scientia.