Re: Retrieving database schema

Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> writes:
> I use the following, although it uses pre-7.0 semantics and may or may not
> work with 7.3
> SELECT relname
> FROM pg_class
> WHERE relkind = 'r' and relname !~ '^Inv'
> and relname !~ '^pg_'
> ORDER BY relname

> I don't remember the reason for the ^Inv regex.

I believe that's a hangover from back when each large object was its own
relation. [digs in archives...] OK, that's dead code since 7.1, and it
was wrong before that ... the special relation names were xin* ...

In 7.3, suppressing relnames starting with 'pg_' isn't really quite the
kosher way to hide system tables, either. It works but it might
suppress legitimate user tables --- there's not a prohibition against
user tables named 'pg_*' anymore. The best way moving forward will be
to ignore tables that are in system schemas.

regards, tom lane