Re: strange system columns - Mailing list pgsql-admin

Colton A Smith <smith@cs.utk.edu> writes:
> SELECT attname, typname, attnum
>                     FROM pg_attribute INNER JOIN pg_type
>                       ON pg_attribute.atttypid = pg_type.typelem
>                         WHERE pg_attribute.attrelid = $oid (derived above)
>                               AND NOT attisdropped;

I think you meant to join to pg_type.oid, not pg_type.typelem.

            regards, tom lane