On Wed, 6 Jun 2001, Markus Wagner wrote:
> The problem is, how to get the names of all tables and their attributes? I
> looked into the system tables ("pg_*"), but there were many tables and
> many attributes for *my* tables, and I did not figure out how to
> distinguish my tables and my attributes from the other ones. None of the
> columns in pg_class and pg_attribute seems to give information on wether
> the item is system or user defined.
IIRC, attnum<0 means it's a system column. So you only want the ones with
positive attnum values.