Search code examples
sqlpostgresqlpgadmin-4

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

Solution

  • 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