SELECT pg_attribute.attname, pg_type.typname, pg_attribute.attnum FROM pg_class LEFT JOIN pg_attribute ON pg_class.oid=pg_attribute.attrelid LEFT JOIN pg_type ON pg_attribute.atttypid=pg_type.oid WHERE pg_attribute.attnum > 0 AND pg_class.…