Question

I am trying to import a txt/csv file into my postgres database from php using "copy" command. I cannot use COPY instead of copy as I need it to execute as a psql client. My code is:

$query =  \ . copy data1 FROM "data1.txt" WITH CSV HEADER DELIMITER AS "," QUOTE AS "^" ;

$result = pg_query($conn,$query);
if (!$result) {
  echo "cannot copy data
";
} else {
  echo "SUCCESS!";
}

当我掌握了这本存放机构档案时,我发现这一错误:

PHP Warning:  pg_query(): Query failed: ERROR:  syntax error at or near ""
LINE 1: copy data1 FROM "data1.txt" WITH ...
    ^ in script.php on line 30

Answer 1

You cannot run copy via pg_query(). It is not an SQL command. It is a meta-command of the psql client.

可以执行:

copy data1 FROM  data1.txt  WITH CSV HEADER DELIMITER AS  ,  QUOTE AS  ^

或者管理着壳体:

psql mydb -c "copy data1 FROM  data1.txt 
                WITH CSV HEADER DELIMITER AS  ,  QUOTE AS  ^ "

Note the quotes. Values need to be single-quoted in PostgreSQL: value .
Double-quotes are for identifiers - and are only actually needed for identifiers with upper case or illegal character or for reserved words: "My table".

Answer 2

我遇到了同样的问题,但决定不使用原始<代码>psqlcopy的指令,而是决定使用<代码>。页: 1 Repo.transaction/1, 正常执行COPY 获取以下数据:;https://experiment withcode.com/using-the-postgres-copy-command-in-ecto-migrations/”rel=“nofollow noreferer”>。我没有测试这一业绩,但我表示,这将是这一答案的一个很好的补充。

友情链接