extract data (insert command) from the pg dump file

Question

I have a postgres dump file which is exported from Heroku app.

Is there any way to export insert commands from the pg dump file or from Heroku app?

Answer 1

If the dump file is plain text - you can use something like grep or other text proceffing tool.

If the dump is binary - use pg_restore --data-only --file=out.sql dump.file

Details: pg_restore