Postgres Pro
Downloads
Home   >   mailing lists

question on SELECT - Mailing list pgsql-sql

From Howard Hiew
Subject question on SELECT
Date
Msg-id 75AEDF97D677D411B8D300D0B746D3E0074543@wolf.mastec.com.sg
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Howard Hiew
Date:
Subject: RE: question on SELECT
Next
From: Jie Liang
Date:
Subject: Re: Problem with function...