In PostgreSQL, you can query foreign key information from:

— `information_schema.table_constraints` for constraint definitions
— `information_schema.key_column_usage` for columns involved in foreign keys
— `information_schema.constraint_column_usage` for referenced columns
— `pg_indexes` for index information
— `pg_attribute` for all column details

These provide comprehensive details similar to MSSQL's system tables.