import MySQL table to PostgreSQL

MySQL-to-PostgreSQL.md

dump MySQL table

mysql -u root -p <dbname> -e 'select * from <table-name>' > /tmp/<table-name>.csv

format csv file:

TABLE_NAME='<table-name>' python -c "import os, pandas as pd;csv_path='/tmp/{}.csv'.format(os.getenv('TABLE_NAME'));df = pd.read_csv(csv_path, sep='\t');df.to_csv(csv_path, header=True, index=False)"

import to PostgreSQL

create database and table in PostgreSQL.

psql -d <dbname>
dbname=# \copy <table-name>("<filed-a>", "<field-b>", ...) from '/tmp/<table-name>.csv' DELIMITER ',' CSV HEADER

Note: if your table column include upper case letter, you must include column name with double quotation marks.

BTW: I can not import with pgLoader