CODEWITHSUNDEEP
sqlpostgresqlpgadmin-4
J.Delannoy
J.Delannoy

Reputation: 375

Running psql with pgAdmin4

I try to open a csv file in PGadmin4 with COPY. However it does not work. The permission is denied and suggests me to use \copy from pgsql.

I tried to replace COPY by \copy, did not work.

I guess that pgsql must be run another way. I saw there ,example with \copy, that it run with a shell file .sh. However I'm using Windows.

How to run pgsql request ?

Thank you

Upvotes: 3

Views: 9818

Answers (2)

Logique
Logique

Reputation: 61

I answer you on my own question page. Yes, psql is the SQL Shell program and you could start it from the Postgresql folder (from where you start pgAdmin). You do not need of psql if you use pgAdmin.

Upvotes: 1

Murtuza Z
Murtuza Z

Reputation: 6017

Try Import/Export option in pgAdmin4 to import your CSV data into Table.

Ref: https://www.pgadmin.org/docs/pgadmin4/dev/import_export_data.html

Upvotes: 1

Related Questions