Hi all, Using pgadmin v. 4.1.1 on a Mac laptop (Sierra), connected to a remote postgres db v. 9.5.5. I am trying to import csv data into the db using the import/export tool. I am importing data from a file on my laptop, so browse to the csv file in the 'Filename' bar. The import fails with a message (with hostnames and usernames anonymized):
<remote_host>:/usr/bin/psql --host "<remote_host>" --port "5432" --username "<user>" --dbname "testdb" --command "\copy public."<target_table>" (id, col1, col2) FROM '/path/to/file/on/local/machine.csv' DELIMITER ',' CSV HEADER QUOTE '"' ESCAPE '''';" which is failing with a message "No such file or directory". So, two questions: 1) How can I import data from a csv file on a local machine to a remote database using pgadmin4? 2) As it is written above, won't the import command be looking for an id column in the csv values? I declared the id field in my schema as a serial datatype, so how can I use the pgadmin4 import tool to import csv values with only two columns? Thanks for any assistance. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
