Migrating to PostgreSQL
Notes on migrating from other relational database systems to PostgreSQL.
MySQL
- Migrating Sakila from MySQL to PostgreSQL
- Using pgLoader to migrate the MySQL sample database
- Some MariaDB -> PostgreSQL Notes
- Insightful article showing how PostgreSQL's stricter typing and validation, while initially painful to adapt for, make for a robuster, more efficient system
Oracle
- TO_DATE() / TO_TIMESTAMP() gotchas
- TO_DATE() is not TO_DATE() - Oracle vs PostgreSQL
- fun with dates when moving from oracle to postgresql
- Differences between Oracle and PostgreSQL when doing calculations with dates