Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eBJ6t8647888 for ; Tue, 19 Dec 2000 01:55:08 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from wolf.mastec.com.sg ([203.120.205.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBJ5is643222 for ; Tue, 19 Dec 2000 00:44:55 -0500 (EST) (envelope-from howard@cim.mastec.com.sg) Received: by wolf.mastec.com.sg with Internet Mail Service (5.0.1461.28) id ; Tue, 19 Dec 2000 13:52:15 +0800 Message-ID: <75AEDF97D677D411B8D300D0B746D3E0074543@wolf.mastec.com.sg> From: Howard Hiew To: pgsql-sql@postgresql.org Subject: question on SELECT Date: Tue, 19 Dec 2000 13:52:12 +0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1461.28) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200012/206 X-Sequence-Number: 540 Hi, I would like to know what is the sql statement that list all the tables name. For example in Oracle, 'SELECT TABLE_NAME from ALL_TABLES where owner="Oracle" '; What is the statement for Postgres? Thank you Best Regards, Howard CIM/MASTEC Tel:(65)8605283