Convert PostgreSQL dump file to MySQL?

Question

I want to convert a PostgreSQL dump file I received to a MYSQL dump file or even sql text to be generated?

Answer 1

If you install the PostgreSQL client programs, you can use "pg_restore" to convert a dump file to a SQL script without having to have a PostgreSQL instance. Just do pg_restore dumpfile.pg and it will print the restore SQL to stdout.

Answer 2

If you have PostgreSQL installed on your terminal and your file is latest.dump you just need to convert it to latest.sql this way:

$ pg_restore latest.dump > latest.sql