PostgreSQL to MariaDB Migration

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

Databases:

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

Migration Reference

Technical information on migration from PostgreSQL to MariaDB.

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

PostgreSQL MariaDB
1 GENERATED AS IDENTITY Identity column AUTO_INCREMENT