Colton A Smith <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
