CODEWITHSUNDEEP
postgresqldatabase-backupspgadmindatabase-restore
Don
Don

Reputation: 4192

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

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?

Upvotes: 2

Views: 15971

Answers (1)

Marlon Abeykoon
Marlon Abeykoon

Reputation: 12465

  • 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.

Upvotes: 12

Related Questions