oracle to PostgreSQL database conversion
PostgreSQL has the SQL_standard information_schema which is actually a bunch of views backed by the pg_catalog schema.

information_schema has a fixed structure as mandated by the standard, pg_catalog is liable to change between major PostgreSQL versions.

For the information you want it's probably the table information_schema.constraint_table_usage.