pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedquestion on SELECT
4+ messages / 3 participants
[nested] [flat]
* question on SELECT
@ 2000-12-19 05:52 Howard Hiew <howard@cim.mastec.com.sg>
2000-12-19 08:12 ` Re: question on SELECT Prasanth A. Kumar <kumar1@home.com>
0 siblings, 1 reply; 4+ messages in thread
From: Howard Hiew @ 2000-12-19 05:52 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: question on SELECT
2000-12-19 05:52 question on SELECT Howard Hiew <howard@cim.mastec.com.sg>
@ 2000-12-19 08:12 ` Prasanth A. Kumar <kumar1@home.com>
2000-12-19 17:25 ` Re: question on SELECT Jie Liang <jliang@jliang.ipinc.com>
0 siblings, 1 reply; 4+ messages in thread
From: kumar1@home.com @ 2000-12-19 08:12 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: question on SELECT
2000-12-19 05:52 question on SELECT Howard Hiew <howard@cim.mastec.com.sg>
2000-12-19 08:12 ` Re: question on SELECT Prasanth A. Kumar <kumar1@home.com>
@ 2000-12-19 17:25 ` Jie Liang <jliang@jliang.ipinc.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jie Liang @ 2000-12-19 17:25 UTC (permalink / raw)
To: Prasanth A. Kumar <kumar1@home.com>; +Cc: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: question on SELECT
@ 2000-12-19 06:17 Howard Hiew <howard@cim.mastec.com.sg>
0 siblings, 0 replies; 4+ messages in thread
From: Howard Hiew @ 2000-12-19 06:17 UTC (permalink / raw)
To: pgsql-sql
Best Regards,
Howard
CIM/MASTEC
Tel:(65)8605283
> -----Original Message-----
> From: Howard Hiew
> Sent: Tuesday, December 19, 2000 1:46 PM
> To: 'pgsql-sql@postgresql.org'
> 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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-12-19 17:25 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-19 05:52 question on SELECT Howard Hiew <howard@cim.mastec.com.sg>
2000-12-19 08:12 ` Prasanth A. Kumar <kumar1@home.com>
2000-12-19 17:25 ` Jie Liang <jliang@jliang.ipinc.com>
2000-12-19 06:17 RE: question on SELECT Howard Hiew <howard@cim.mastec.com.sg>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox