[pgadmin-support] pgadmin4 import csv issue
От | Huston Bokinsky |
---|---|
Тема | [pgadmin-support] pgadmin4 import csv issue |
Дата | |
Msg-id | CAPMzu8x=2W=hqne1oZS8ZJMjbA7PR+ts4YSUZmetzOdkzzuV_Q@mail.gmail.com обсуждение исходный текст |
Список | pgadmin-support |
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.
В списке pgadmin-support по дате отправления: