FROM pg_attribute A INNER JOIN pg_class C on A .attrelid = C .oid INNER JOIN pg_type T on A .atttypid = T .oid LEFT JOIN ( SELECT conrelid, unnest(conkey) as pk FROM pg_constraint WHERE contype = ' p ' ) S ON S.conrelid = C .oid AND A.attnum = S.pk LEFT JOIN pg_description d on d.objoid = A .attrelid AND d.objsubid = A .attnum LEFT JOIN pg_namespace n on n.oid = c.relnamespace WHERE A.attnum > 0 AND n.nspname = ' public ' AND C.relname = ' t_gfecp_bigdata_blacklist ' ORDER BY C .relname, A .attnum