SQL adaptation guide For PostgreSQL 8.x.y, 9.x.y / Data dictionary |
When creating a table, Informix® automatically adds a ROWID integer column (applies to non-fragmented tables only). The ROWID column is auto-filled with a unique number and can be used like a primary key to access a given row.
When the feature is enabled, PostgreSQL tables are automatically created with a OID column (Object Identifier) of type INTEGER. The behavior is equivalent to Informix ROWID columns (see Solution).
The database automatically converts ROWID keywords to OID for PostgreSQL. You can execute "SELECT ROWID FROM" and "UPDATE .. WHERE ROWID = ?" statements as with Informix.