CODEWITHSUNDEEP
postgresql
Nick Binnet
Nick Binnet

Reputation: 1990

pgAdmin III Restore PLAIN Backup

New to PostgreSQL database, I found column names were automatically converted to lowercase. I created a PLAIN backup, manually edited the column names to proper case. When I tried to restore the edited PLAIN backup, the OK button of pgAdmin3 Restore was disabled.

Is there a way run the edited plain backup file? Please help.

Upvotes: 16

Views: 28442

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 126970

Use the client program psql to restore, works fine. The installers of pgAdmin and PostgreSQL also install psql, so you should have it on your pc or your database server.

psql -f backup.sql postgres

Upvotes: 25

Related Questions