Categories
MAR
14
24
Columns when migrating from Oracle to Postgres?
When Migrating Schema from Oracle to Postgres, there are few object differences to pay attention to in which one of the object is columns.
Before version 12, PostgreSQL didn't have something like virtual columns, which are columns whose values are automatically computed based on other columns' values. When migrating from Oracle, users were advised to use views instead of virtual columns. Now, PostgreSQL has something called generated columns, which are similar to Oracle's virtual columns.
There are few other components related to columns which we have to Pay attention to when migrating from oracle to Postgres such as Data type, Sequences, Identity Columns, Indexing, Null Values, Identifiers.