There is a MySQL database dump - dump.the sql
that I gave third-party developers. Encoding - cp1251
Need to migrate to postgresql
What they do:
1) restore the dump into the database(developers in its own way it unloaded, so I decided to take a dump on your own)
2) do your dump
mysqldump --compatible=postgresql -u root catalog > dump.sql
3) convert the dump to postgresql
(I know that this is just a text file, but nevertheless easy to restore from the sql did not work)
Doing this utility https://github.com/lanyrd/mysql-postgresql-converter
python db_converter.py dump.sql pg_dump
4) Try to restore
psql pg_database < pg_dump
At this point out this error
invalid command \"?????????
ERROR: syntax error at or near "0"
LINE 5: "price" float NOT NULL DEFAULT '0',
Tell me what's the problem? how to fix these errors?