Horton

Re: [SQL] list of tables?

jose' soares <sferac@bo.nettuno.it>

View thread View on postgr.es
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>
Date: 1998-05-21T09:26:52Z
Lists: pgsql-sql 
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'