Restore Postgres database schema from *.sql file via pgAdmin?

Question

I have several *.sql dump files that I would like to restore to a newly created database 'spatial_db'. I know that I can restore them via command line:

psql -U username -h 127.0.0.1 -d spatial_db -f path/to/dump/file.sql

Is there a way to restore the *.sql file(s) via pgAdmin as with *.backup files?

Marlon Abeykoon · Accepted Answer · 2017-04-14 06:33:57Z

12

Create the new db spatial_db.
Select the created db and go to Menu->Plugins->PSQL Console
Type the command to import the db \i /path/to/file.sql

Also if it is a small file you can open it in editor and execute the sql statements.

answered Apr 14, 2017 at 6:33

Marlon Abeykoon

12.6k4 gold badges60 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

chrisfs Over a year ago

I'm sorry, I am confused. I have PGAdmin4 , I have created a new empty database, but when I select it, I don't see an option that says Menu anywhere. If I look at the right click menu, it doesn't have an option called 'Plugins'. What am I missing here ?

Marlon Abeykoon Over a year ago

This answer is for PGAdminIII

Nathan123 Over a year ago

@MarlonAbeykoon what if the file is in the .bak format. I am using pgadmin 3. Would this still work?

Collectives™ on Stack Overflow

Restore Postgres database schema from *.sql file via pgAdmin?

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related