PostgreSQL to MySQL Migration

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

Databases:

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

Migration Reference

Technical information on migration from PostgreSQL to MySQL.

CREATE TABLE

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

	PostgreSQL		MySQL
1	GENERATED AS IDENTITY	Identity column	AUTO_INCREMENT