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