Question

我正试图将数据从小数输入邮政。我尝试了以下错误:

Copy TA_Files 
FROM  C:UsersABla47DocumentsTA 11.19.21.csv 
DELIMITER  , 
CSV HEADER;

ERROR: could not open file "C:UsersABla47DocumentsTA 11.19.21.csv" for reading: Permission denied

HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as psql s copy.

SQL state: 42501

然后,我尝试:

Copy TA_Files 
FROM  DocumentsTA 11.19.21.csv 
DELIMITER  , 
CSV HEADER;

ERROR: syntax误差 at or near ""”

LINE 1: Copy TA_Files

谁能帮助我知道,我需要用什么格式将数据从碎块输入表格?

增编

Answer 1

this worked for me:
I placed the files in C:Program FilesPostgreSQL14pgAdmin 4 directory and copied it from there.

COPY superstore_people(person, region)
FROM  C:Program FilesPostgreSQL14pgAdmin 4superstore_people.csv 
DELIMITER  , 
CSV HEADER;

Answer 2

这个问题很晚,但刚刚出现,在停滞不前的情况下却看不到这一解决办法。这是我最简单的解决办法。

https://www.commandprompt.com/education/how-to-fix-permission-denied-error-while-importing-a-csv-file-in-postgresql/“rel=” https://www.commandprompt.com/education/how-to-fix-permission-denied-error-while-importing-a-csv-file-in-postgresql/

只是要提交财产——和;安全——和;编辑——和;然后是物体名称类型人人: - &;应用变化

Answer 3

我抄送邮袋的文档为进口<编码>CSV文档。

友情链接