Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 9EF804760FD for ; Wed, 15 May 2002 00:57:08 -0400 (EDT) Received: from smtp7.jaring.my (smtp7.jaring.my [61.6.32.57]) by postgresql.org (Postfix) with ESMTP id ADA9D4760C5 for ; Wed, 15 May 2002 00:57:06 -0400 (EDT) Received: from eware.com.my (j78.jhb36.jaring.my [161.142.134.92]) by smtp7.jaring.my (8.11.4/8.11.4) with ESMTP id g4F4v4U11639 for ; Wed, 15 May 2002 12:57:06 +0800 (MYT) Message-ID: <3CE1E8DB.4000105@eware.com.my> Date: Wed, 15 May 2002 12:49:31 +0800 From: Ang Tun Chek User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.5) Gecko/20011101 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: some questions Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200205/153 X-Sequence-Number: 7789 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? thank you