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 eBJ6kp646679 for ; Tue, 19 Dec 2000 01:46:51 -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 eBJ69n644216 for ; Tue, 19 Dec 2000 01:09:49 -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 14:17:16 +0800 Message-ID: <75AEDF97D677D411B8D300D0B746D3E0074550@wolf.mastec.com.sg> From: Howard Hiew To: pgsql-sql@postgresql.org Subject: RE: question on SELECT Date: Tue, 19 Dec 2000 14:17:14 +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/205 X-Sequence-Number: 539 Best Regards, Howard CIM/MASTEC Tel:(65)8605283 > -----Original Message----- > From: Howard Hiew > Sent: Tuesday, December 19, 2000 1:46 PM > To: 'pgsql-sql@postgresql.org' > Subject: question on SELECT > > 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 >