These are the functions which exist in both Oracle and PostgreSQL database. The name and operations are also same in both the databases.
Following are the list of functions which behave the same in Oracle and PostgreSQL. So, while migrating from an Oracle database to PostgreSQL, you need not worry on converting these functions.
Character Functions
Built-in function
Description
Oracle
Postgres
UPPER
It converts character values to upper case.
SELECT upper(‘db Migration’) FROM DUAL;
SELECT upper(‘db Migration’);
LOWER
It converts character values to lower case.
SELECT lower(‘db Migration’) FROM DUAL;
SELECT lower(‘db Migration’);
INITCAP
It takes a string and converts first character of each word to upper case and keeps all other letters in lower case. For INITCAP, words are delimited either by white space or characters that are not alpha-numeric.
select initcap(‘Data.base mig-r$ation’) FROM DUAL;
