SELECT pg_constraint.conname AS pk_name, pg_attribute.attname AS colname, pg_type.typname AS typename, pg_stat_all_tables.schemaname as "schemaname", pg_stat_all_tables.relname as "table", cast(obj_description(relfilenode,'pg_class') as varchar) as comment FROM pg_constraint INNER JOIN pg_class ON pg_constraint.conrelid = pg_class.OID INNER JOIN pg_attribute ON pg_attribute.attrelid = pg_class.OID AND pg_attribute.attnum = pg_constraint.conkey [ 1 ] INNER JOIN pg_type ON pg_type.OID = pg_attribute.atttypid INNER JOIN pg_stat_all_tables ON pg_stat_all_tables.relid = pg_class.OID WHERE pg_stat_all_tables.schemaname = 'public' AND pg_constraint.contype = 'p';
|