如何列出PostgreSQL中所有表的所有约束？

SELECT
    conname AS constraint_name,
    conrelid::regclass AS table_name,
    pg_get_constraintdef(c.oid) AS constraint_definition
FROM
    pg_constraint c
JOIN
    pg_namespace n ON n.oid = c.connamespace
WHERE
    n.nspname = 'public' -- 替换为你的模式名称
ORDER BY
    conrelid::regclass::text,
    conname;