pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rolf Hug <rolfhug@bluewin.ch>
To: pgsql-sql@postgresql.org
Subject: Re: all tables in a DB\?
Date: Mon, 18 Feb 2002 21:28:15 +0100
Message-ID: <a4ro0l$1641$1@jupiter.hub.org> (raw)
References: <Xh2c8.20270$tg4.228609@vixen.cso.uiuc.edu>

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?
>
>
>
>





view thread (4+ messages)  latest in thread

Message-ID: <a4ro0l$1641$1@jupiter.hub.org>
Permalink:  ../a4ro0l$1641$1@jupiter.hub.org/
Also on:    postgresql.org/message-id/a4ro0l$1641$1@jupiter.hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: rolfhug@bluewin.ch
  Subject: Re: all tables in a DB\?
  In-Reply-To: <a4ro0l$1641$1@jupiter.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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