Re: question on SELECT

Howard Hiew <howard@cim.mastec.com.sg> writes:

> 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

You can do '\dt' to list all tables. There is also a system table
'pg_tables' which you can use if you like to do a select instead. DoSELECT tablename FROM pg_tables where
tableowner='postgres';

-- 
Prasanth Kumar
kumar1@home.com