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.

• SQLines Data - Data Transfer, Schema Migration and Validation tool
• SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online

Databases:

• PostgreSQL 18.x, 17.x, 16.x, 15.x, 14.x, 13.x, 12.x, 11.x, 10.x and 9.x
• MariaDB 12.x, 11.x, 10.x and 5.x

• Data Types
• CREATE TABLE

Converting date and time data types:

	PostgreSQL		MariaDB
1	TIMESTAMP(p) WITH TIME ZONE	Date and time with fraction and time zone	DATETIME(p)

Converting CREATE TABLE statement keywords and clauses: