MySQL to PostgreSQL Migration

SQLines provides tools to help you transfer data, convert database schema (DDL), views, stored procedures and functions, triggers, queries, embedded SQL statements and SQL scripts from MySQL to PostgreSQL.

Databases:

  • MySQL 8.x and 5.x
  • PostgreSQL 14.x, 13.x, 12.x, 11.x, 10.x and 9.x

MySQL to PostgreSQL Migration Tools

MySQL to PostgreSQL Migration Reference

Language Elements

Converting SQL language elements:

MySQL PostgreSQL
1 -- # Single line comment --

Other:

Data Types

Converting character data types:

MySQL PostgreSQL
1 LONGTEXT Character large object, <= 4 Gb TEXT

Converting numeric data types:

MySQL PostgreSQL
1 FLOAT(p, s) Single-precision floating point FLOAT(p)
2 INT(m) 32-bit integer INT

Converting datetime data types:

MySQL PostgreSQL
1 DATETIME(p) Date and time data with fraction, p <= 6, default is 0 TIMESTAMP(p)

Converting binary data types:

MySQL PostgreSQL
1 LONGBLOB Binary large object, <= 4 Gb BYTEA
2 TINYBLOB Binary data, <= 255 bytes BYTEA

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

MySQL PostgreSQL
1 AUTO_INCREMENT column property Sequence and DEFAULT nextval('seq_name')
2 COLLATE name Removed

Storage and table attributes:

MySQL PostgreSQL
1 AUTO_INCREMENT = start_value table option ALTER SEQUENCE seq_name RESTART WITH start_value
2 ENGINE = engine_name Removed

Other SQL Statements

Converting other SQL statements:

MySQL PostgreSQL
1 CREATE DATABASE [IF NOT EXISTS] name CREATE DATABASE name
2 DROP TABLE [IF EXISTS] table DROP TABLE [IF EXISTS] table