1. Home
  2. Docs
  3. Oracle to PostgreSQL Migration
  4. 3 Built-in Functions

3 Built-in Functions

What you’ll learn in this Chapter

✓ Which are the Oracle built-in functions that behave the same way in PostgreSQL database?
✓ Which are the Oracle built-in functions that behave differently in PostgreSQL database?
✓ Which are the Oracle built-in functions not supported in PostgreSQL database? How to handle those?
✓ How is type casting in PostgreSQL functions important?

Overview

Oracle and PostgreSQL are two different databases and hence have their own SQL versions. Oracle as a commercial database has many built-in functions to provide user the flexibility to make data access simpler and development tasks easier.

While migrating to PostgreSQL database, many of the built-in functions are supported as is while many requires little changes. There are some Oracle functions that are not available in PostgreSQL or you do not have a direct function available. In those cases it is the job of the developer to write logic in PostgreSQL to migrate that functionality in PostgreSQL.

Through this chapter, we discuss on all frequently used Oracle functions and their equivalent functionality in PostgreSQL.

Articles

Was this article helpful to you? Yes No

How can we help?