# from MySQL to PostgreSQL

DevFeed: [from MySQL to PostgreSQL](<https://devfeed.tech/articles/from-mysql-to-postgresql-34561.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2017/07/from-mysql-to-postgresql/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2017-07-06T15:30:11Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>)

Tags: [command-line](<https://devfeed.tech/tags/command-line.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article announces pgloader 3.4.1 and describes migrating MySQL databases to PostgreSQL. It explains that pgloader can transfer schemas, indexes, constraints, comments, and default values in a single command, and notes support for converting MySQL spatial keys to PostgreSQL GiST indexes.

## Source excerpt

Today pgloader v3.4.1 is released and available! This new release comes with 110 commits as show in github compare view. This release of pgloader is following the tradition of simplifying things for users, or if you allow me to quote Alan Kay, I believe that if simple things should be simple, complex things should be possible.