Petr Zcech
Petr Zcech

Reputation: 11

How to open db.dump from Ubuntu on Windows 7

Is there a way how to open a database .dump file from Ubuntu on Windows 7 in PostgreSQL?
I have created an empty database in PgAdmin 3 and then tried to restore it with the db.dump but it did not work.

Upvotes: 1

Views: 206

Answers (1)

CoryatJohn
CoryatJohn

Reputation: 324

If you created the file using pg_dump or pg_dumpall, then you can restore it by using the

psql -f <file name> 

if it's from pg_dumpall or

psql -f <file name> <database name> 

if it's from pg_dump.

Upvotes: 1

Related Questions