This select shows all constraints for all tables in point of view of every table. So there are of course duplicities but we can see all constraints for table at once.

select * from (
select
CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG,
TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME,
ORDINAL_POSITION, POSITION_IN_UNIQUE_CONSTRAINT,
REFERENCED_TABLE_SCHEMA, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
from information_schema.KEY_COLUMN_USAGE u
union
select
CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME, TABLE_CATALOG,
REFERENCED_TABLE_SCHEMA as TABLE_SCHEMA, REFERENCED_TABLE_NAME as TABLE_NAME, REFERENCED_COLUMN_NAME as COLUMN_NAME,
ORDINAL_POSITION, POSITION_IN_UNIQUE_CONSTRAINT,
TABLE_SCHEMA as REFERENCED_TABLE_SCHEMA, TABLE_NAME as REFERENCED_TABLE_NAME, COLUMN_NAME as REFERENCED_COLUMN_NAME
from information_schema.KEY_COLUMN_USAGE u
where REFERENCED_TABLE_NAME is not null
) a
where a.CONSTRAINT_SCHEMA='...my_schema_name...'
order by TABLE_NAME, CONSTRAINT_NAME, ORDINAL_POSITION