As organizations modernize their database infrastructure, migrating from Oracle to open source solutions like PostgreSQL is increasingly common, although it presents significant challenges.
"Historically, the most common way of defining primary keys in PostgreSQL was with the serial type, but now the official documentation advises against them in favor of identity columns."