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?

score 2 · Accepted Answer · answered Oct 08 '13 at 11:58

2

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

answered Oct 08 '13 at 11:58

Ihor Romanchenko

1 Answers1