[SQL] RE: question on SELECT

2000-12-18 Thread Howard Hiew 



Best Regards,
Howard
CIM/MASTEC
Tel:(65)8605283

>  -Original Message-
> From:     Howard Hiew  
> Sent: Tuesday, December 19, 2000 1:46 PM
> To:   '[EMAIL PROTECTED]'
> 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
>

[SQL] question on SELECT

2000-12-18 Thread Howard Hiew 

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