Is there a way to convert a Postgres dump file to a text file?
I'm experiencing issues getting the dump to the proper file location of I would just restore from the dump file and then export to text.
Here's what lastest.dump looks like:
Postgresql – Postgres Dump To TXT File
dumppg-dumppostgresql
Related Question
- Postgresql – pg_dump inserting C source code in dump file
- PostgreSQL – How to Perform Partial Dump of Large Objects (pg_largeobject Table)
- Postgresql – How to disable foreign key constraints in the Postgres dump file
- Difference in database dump file size
- PostGIS DB Dump/Restore Errors on EC2 to RDS – Solutions
- Postgresql – Cannot restore postgres dump file
- Postgresql – How to dump a Postgres table and restore under another user/role
Best Answer
This is a dump file produced by
pg_dump -Fc.To create a text file containing SQL commands from it, use pg_restore.
The basic syntax is
pg_restore file.dump > file.sql, that is, you don't specify a target database (notice the missing-doption).