Best results in other decks

When dumping your Heroku Postgre database (with heroku pg:backups:capture --app my-app and heroku pg:backups:download --app my-app), it will result in a binary dump.

...also a flag to omit the schema and output only the data of the dump: --data-only. This may be useful if you can restore the schema otherwise, e.g. when...

If you have a PostgreSQL dump in the custom format you can can view the text format dump (plain SQL statements). PostgreSQL 12 and newer Write it as a textdump...

pg_restore $dumpname -f name.textdump Applying parameters You can apply the same parameters for the output of the textdump as for restoring the dump (for e.g. --clean...