Re: parsing relname in pg_class

"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> I'm writing a perl script where I only want to parse
> out a list of tables from the database I'm connecting
> to.

> select relname from pg_class
> where relname not like '%_i%';

That doesn't seem very helpful; what's worse is it might hide tables you
want.  Something like

select relname from pg_class
where relname not like 'pg\\_%' and relkind = 'r';

would probably be a lot closer to what you want.

            regards, tom lane