Horton

Re: [SQL] list of tables?

Oleg Broytmann <phd@comus.ru>

View thread View on postgr.es
From: Oleg Broytmann <phd@comus.ru>
To: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
Cc: pgsql-sql@postgreSQL.org
Date: 1998-05-21T09:30:09Z
Lists: pgsql-sql 
Hello!

   I see this SELECT every other day in mailbox. Isn't it a FAQ?

On Thu, 21 May 1998, Jose' Soares Da Silva wrote:
> -- 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;

Oleg.
---- 
  Oleg Broytmann     http://members.tripod.com/~phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.