Linkedin

Migrate Oracle ROWID functionality to PostgreSQL on AWS

Project Overview

Project Detail

This pattern describes options for migrating the ROWID pseudocolumn functionality in Oracle Database to a PostgreSQL database in Amazon Relational Database Service (Amazon RDS) for PostgreSQL, Amazon Aurora PostgreSQL-Compatible Edition, or Amazon Elastic Compute Cloud (Amazon EC2).

In an Oracle database, the ROWID pseudocolumn is a physical address of a row in a table. This pseudocolumn is used to uniquely identify a row even if the primary key isn’t present on a table. PostgreSQL has a similar pseudocolumn called ctid, but it cannot be used as a ROWID. As explained in the PostgreSQL documentationctid might change if it’s updated or after every VACUUM process

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-oracle-rowid-functionality-to-postgresql-on-aws.html?did=pg_card&trk=pg_card

To know more about this project connect with us

Migrate Oracle ROWID functionality to PostgreSQL on AWS