From: Jose' Soares Da Silva <sferac@bo.nettuno.it>
To: The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-sql@postgreSQL.org, "Rosauro, Guillaume" <Guillaume.Rosauro@matra-com.fr>
Subject: Re: [SQL] list of tables?
Date: Thu, 21 May 1998 09:26:52 +0000 (UTC)
Message-ID: <Pine.LNX.3.96.980521092612.361A-100000@proxy.bazzanese.com> (raw)
In-Reply-To: <Pine.BSF.3.96.980520230250.18610L-100000@thelab.hub.org>
On Wed, 20 May 1998, The Hermit Hacker wrote:
>
> Hello
>
> I d like to know if it is possible to have the list of tables like we can do with psql with \dt
>
> thanks
>
-- list all and only tables/views...
SELECT usename, relname
FROM pg_class, pg_user
WHERE ( relkind = 'r')
AND relname !~ '^pg_'
AND relname !~ '^xin[vx][0-9]+'
AND usesysid = relowner
ORDER BY relname;
Jose'
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: sferac@bo.nettuno.it, scrappy@hub.org, Guillaume.Rosauro@matra-com.fr
Subject: Re: [SQL] list of tables?
In-Reply-To: <Pine.LNX.3.96.980521092612.361A-100000@proxy.bazzanese.com>
* 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