I want to import dump.psql file to PostgreSQL.
Postgres admin panel only supports executing sql files not psql. How can I do this?
Asked
Active
Viewed 219 times
0
-
If your dump file is a SQL (aka "plain text") dump, then just run it with `psql`. What exactly is this "admin panel" you are talking about? Postgres doesn't have an "admin panel". – Sep 10 '15 at 11:03
-
If it's a dump for `pg_restore`, PgAdmin has a "restore" option when you right click on database. Create a new blank database, right click, restore, etc. Otherwise use `psql -f ...` – Craig Ringer Sep 10 '15 at 12:51