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.
It converts character values to upper case.
SELECT upper(‘db Migration’) FROM DUAL;
SELECT upper(‘db Migration’);
It converts character values to lower case.
SELECT lower(‘db Migration’) FROM DUAL;
SELECT lower(‘db Migration’);
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;