There is a detailed explanation of this difference here. There is no static analyser tool going to check and help fixing those in advance. We end up checking such empty string only with the help of testing, going back to code to fix them.
In short, keep following in mind,
- Oracle considers Empty String(”) and NULL as null
- PG considers Empty String as Empty String and NULL as null.