Howard Hiew <howard(at)cim(dot)mastec(dot)com(dot)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. Do
SELECT tablename FROM pg_tables where tableowner='postgres';
--
Prasanth Kumar
kumar1(at)home(dot)com