Migrating data
From CSV to Postgres via sqlite3
Section titled “From CSV to Postgres via sqlite3”1. Load the csv into sqlite3
Section titled “1. Load the csv into sqlite3”sqlite3 mydb.sqlite3
.mode csv.import my_csv.csv mytable2. Use pgloader to transfer the data from sqlite to postgres
Section titled “2. Use pgloader to transfer the data from sqlite to postgres”pgloader --type sqlite sqlite://mydb.sqlite3 postgresql:///app?host=/home/me/tmp/mydb