pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
all 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