"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)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