Mastering PostgreSQL 12 - Third Edition

Common pitfalls

There are some very basic syntax elements that work in Oracle, but they might not work in PostgreSQL. This section lists some of the most important pitfalls to take into consideration. Of course, this list is not complete by any means, but it should point you in the right direction.

In Oracle, you may come across the following statement:

DELETE mytable;

In PostgreSQL, this statement is wrong since PostgreSQL requires that you use a FROM clause in the DELETE statement. The good news is that this kind of statement is easy to fix.

The next thing you might find is the following:

SELECT sysdate FROM dual;

PostgreSQL has neither a sysdate function nor a dual function. The dual function part is easy to fix as you can simply create ...