Blogs

When Migrating Schema from Oracle to Postgres, there are few object differences to pay attention to in which one of the object is Identifier.

In Oracle, names of schemas, tables, columns, and functions are automatically converted to uppercase unless they're put inside quotes. But in PostgreSQL, they're converted to lowercase unless they're quoted. As long as you're consistent in how you quote or don't quote these names in your application, everything should work smoothly during migration.

There are few other points related to Identifiers which we have to Pay attention to when migrating from oracle to Postgres such as quoting rules: while both databases use double quotes, PostgreSQL primarily uses them to preserve case, while Oracle uses them for special characters and case sensitivity and maximum identifier length (limited to 30 bytes in Oracle, up to 63 bytes in PostgreSQL).