Postgres Dump To TXT File

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.

Really I just need to import it into a SQLite database.

I think it's a binary dump. Here's what latest dump looks like:

This is a dump file produced by pg_dump -Fc. The dump may or may not contain the data depending on the options it was made with.

To create a text file containing SQL commands from it, use pg_restore.

The basic syntax is pg_restore -f output.sql file.dump, that is, you don't specify a target database (notice the missing-d option). -f- may be used instead of -f output.sql to send the SQL script to the standard output.

StackExchange Database Administrators Q#49369, answer score: 18