]

The file itself (unless it’s a binary file) can be opened in a text editor to inspect. To create a database to work with from the backup file, you have to create a database to restore into and then restore the database.

To create:

$ psql -U postgres
postgres=# createdb dbname

To restore from the backup:

psql -U postgres -d dbname -f path/to/your/file.sql