CODEWITHSUNDEEP
postgresqlpsqldatabase-dump
Ray92
Ray92

Reputation: 453

importing a .sql db dump postgres 11, pgadmin 4

I have a SQL dump file: C:\Users\Rayyan\Desktop\dump_2.sql.

I have been trying to import this for so long. I am using pgadmin 4, and since I could find nothing in that gui to help, I tried using psql console (I'm on windows).

So I created my new database "wecudos" in pgadmin4.

Then tried the following command in psql console:

psql wecudos < C:\Users\Rayyan\Desktop\dump_2.sql

according to the specified format:

psql dbname < dumpfile

This is not working, please help, I have also added a screenshot of the error/data I entered, thanks!

enter image description here

Upvotes: 0

Views: 4734

Answers (1)

Renny
Renny

Reputation: 64

You need to click on the Tools tab in the top > Query Tool. Then click on the folder icon in the Query Editor area > then select the location of the SQL file.

Upvotes: 0

Related Questions