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(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.