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
[EMAIL PROTECTED]
www.ipinc.com
On 19 Dec 2000, Prasanth A. Kumar wrote:
> Howard Hiew <[EMAIL PROTECTED]> wri
Howard Hiew <[EMAIL PROTECTED]> 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
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
