Heroku postgresql snapshot dump file

Question

Is there a way to import .dump file from Heroku to pgadmin?

I've tried something like below in SQL editor

pg_restore -c -d virtual b003.dump

but I'm getting

ERROR:  syntax error at or near "pg_restore"
LINE 1: pg_restore -c -d virtual b003.dump
        ^
********** Error **********

ERROR: syntax error at or near "pg_restore"
SQL state: 42601
Character: 1

Related: stackoverflow.com/q/7265704/398670

Craig Ringer
– Craig Ringer

2014-02-28 22:59:47 +00:00
Commented Feb 28, 2014 at 22:59 — Craig Ringer
– Craig Ringer, Commented Feb 28, 2014 at 22:59

Milen A. Radev · Accepted Answer · 2014-02-28 13:25:41Z

1

pg_restore is a command-line tool, not a SQL command. pgAdmin has its own UI for restoring DB dumps

answered Feb 28, 2014 at 13:25

Milen A. Radev

63.3k22 gold badges111 silver badges113 bronze badges

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

Collectives™ on Stack Overflow

Heroku postgresql snapshot dump file

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related