如何在PostgreSQL9.5中检索特定模式的所有键及其列名和表名？

SELECT
    conname AS constraint_name,
    conrelid::regclass AS table_name,
    a.attname AS column_name
FROM
    pg_constraint c
JOIN
    pg_attribute a ON a.attnum = ANY(c.conkey) AND a.attrelid = c.conrelid
JOIN
    pg_namespace n ON n.oid = c.connamespace
WHERE
    n.nspname = 'your_schema_name'
    AND c.contype = 'f'
ORDER BY
    conname;