Become Zend Certified

Prepare for the ZCE exam using our quizzes (web or iPad/iPhone). More info...

When you're ready get 7.5% off your exam voucher using voucher CJQNOV23 at the Zend Store

Migrating From MySQL To PostgreSQL In PHP


Every row that exists in a PostgreSQL database has an OID column associated with it. When you normally select data from a table (e.g. select * from myTable) you won’t see this field, but try the following and see what you get:

Listing 8 listing-8.sql
select oid, * from myTable;

Think of this an internal unique ID the database server uses to keep track of your data.

Note: As of PostgreSQL 8.1 the oid column is not automatically created.

In This Article