question on SELECT

From: Howard Hiew <howard(at)cim(dot)mastec(dot)com(dot)sg>
To: pgsql-sql(at)postgresql(dot)org
Subject: question on SELECT
Date: 2000-12-19 05:52:12
Message-ID: 75AEDF97D677D411B8D300D0B746D3E0074543@wolf.mastec.com.sg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Howard Hiew 2000-12-19 06:17:14 RE: question on SELECT
Previous Message Jie Liang 2000-12-19 03:21:23 Re: Problem with function...