Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
Fix for issue #1622 - changed query to look at unique constraints from PostgreSQL catalog table pg_constraint.
Note that this query only detects actual UNIQUE CONSTRAINTS. It does not count UNIQUE INDEXES without a corresponding constraint which arguably, effectively provides the same result. However, this is okay as this behaviour is the same with the corresponding Oracle query. Further, INDEXES are counted and compared in the previous section.
Fix for issue #1622 - changed query to look at unique constraints from PostgreSQL catalog table
pg_constraint
.Note that this query only detects actual UNIQUE CONSTRAINTS. It does not count UNIQUE INDEXES without a corresponding constraint which arguably, effectively provides the same result. However, this is okay as this behaviour is the same with the corresponding Oracle query. Further, INDEXES are counted and compared in the previous section.