pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedall tables in a DB\?
4+ messages / 4 participants
[nested] [flat]
* all tables in a DB\?
@ 2002-02-18 07:51 D'laila Pereira <dlailap@home.com>
2002-02-18 20:28 ` Re: all tables in a DB\? Rolf Hug <rolfhug@bluewin.ch>
2002-02-22 03:10 ` Re: all tables in a DB\? Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 2 replies; 4+ messages in thread
From: D'laila Pereira @ 2002-02-18 07:51 UTC (permalink / raw)
To: pgsql-sql
What SQL command can I issue in Postgresql to list all the tables in a
database?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: all tables in a DB\?
2002-02-18 07:51 all tables in a DB\? D'laila Pereira <dlailap@home.com>
@ 2002-02-18 20:28 ` Rolf Hug <rolfhug@bluewin.ch>
1 sibling, 0 replies; 4+ messages in thread
From: Rolf Hug @ 2002-02-18 20:28 UTC (permalink / raw)
To: pgsql-sql
Hi
Try the following SQL-Command:
SELECT relname
FROM pg_class
WHERE relname NOT LIKE 'pg_%';
In the table 'pg_class' you will find all tables created in the database.
Also the system-tables called pg_... (like pg_class).
greetings
rolf
"D'laila Pereira" <dlailap@home.com> schrieb im Newsbeitrag
news:Xh2c8.20270$tg4.228609@vixen.cso.uiuc.edu...
> What SQL command can I issue in Postgresql to list all the tables in a
> database?
>
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: all tables in a DB\?
2002-02-18 07:51 all tables in a DB\? D'laila Pereira <dlailap@home.com>
@ 2002-02-22 03:10 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
1 sibling, 0 replies; 4+ messages in thread
From: Christopher Kings-Lynne @ 2002-02-22 03:10 UTC (permalink / raw)
To: D'laila Pereira <dlailap@home.com>; pgsql-sql
select * from pg_table;
Chris
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of D'laila Pereira
> Sent: Monday, 18 February 2002 3:52 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] all tables in a DB\?
>
>
> What SQL command can I issue in Postgresql to list all the tables in a
> database?
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: all tables in a DB\?
@ 2002-02-21 21:21 Jie Liang <jie@stbernard.com>
0 siblings, 0 replies; 4+ messages in thread
From: Jie Liang @ 2002-02-21 21:21 UTC (permalink / raw)
To: D'laila Pereira <dlailap@home.com>; pgsql-sql
\dt
Jie Liang
-----Original Message-----
From: D'laila Pereira [mailto:dlailap@home.com]
Sent: Sunday, February 17, 2002 11:52 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] all tables in a DB\?
What SQL command can I issue in Postgresql to list all the tables in a
database?
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-02-22 03:10 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-02-18 07:51 all tables in a DB\? D'laila Pereira <dlailap@home.com>
2002-02-18 20:28 ` Rolf Hug <rolfhug@bluewin.ch>
2002-02-22 03:10 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-02-21 21:21 Re: all tables in a DB\? Jie Liang <jie@stbernard.com>
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