PGCon2007 - Confirmed

PGCon 2007
The PostgreSQL Conference

Brian Dunavant
Day 3
Room SITE A0150
Start time 10:00
Duration 01:00
ID 17
Event type Lecture
Track Basics
Language English

Oracle to PostgreSQL Conversion

Transition from Oracle to a PostgreSQL database can be confusing. This presentation provides someone new to PostgreSQL with many of the differences they will need to overcome and some tricks to do so.

While Oracle is an excellent database, costs for a PostgreSQL database are significantly less. The goal of this talk is to provide the attendee with basic knowledge they must have in order to meet the challenge of an Oracle to PostgreSQL transition. Included are some of the differences between the systems as well as PostgreSQL-specific quirks that aren't readily apparent to someone used to Oracle. We will address some of the short comings of PostgreSQL from an Oracle perspective and how these are dealt with when translating SQL queries or table setups. This is targeted towards a developer with at least passing familiarity using PostgreSQL.

The talk will cover some of the differences in data types between the two systems and what implications this has on setting up the new translated versions of your Oracle tables on PostgreSQL. Once tables are created we move on to differences in the actual SQL query syntax and provide PostgreSQL solutions to some Oracle specific functions. Basic differences between Oracle Stored Procedures and PostgreSQL functions are explored as well as the difference in trigger implementation. Handful of clever and/or novel hacks will be presented that lessen the divide between Oracle and PostgreSQL.

  • Structure Differences
  • SQL Query Differences
  • Stored Procedures/Functions
  • Triggers
  • Getting The Data