use:
\dt -- all tables
\dv -- all views
\df -- all functions
...
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.ipinc.com
On 19 Dec 2000, Prasanth A. Kumar wrote:
> 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. Do
> SELECT tablename FROM pg_tables where tableowner='postgres';
>
> --
> Prasanth Kumar
> kumar1@home.com
>