postgres抛出的copy from语法错误

sshcrbum  于 2021-08-09  发布在  Java
关注(0)|答案(1)|浏览(519)

我正在尝试将数据从管道分隔的文本文件导入我的postgres data_master table。我的命令如下:

  1. COPY data_master FROM '/Users/me/Documents/DATA/39079.txt'
  2. WITH FORMAT csv,
  3. DELIMITER '|',
  4. HEADER TRUE;

错误如下:

  1. temp=# COPY data_master FROM '/Users/me/Documents/DATA/39079.txt' WITH FORMAT csv, DELIMITER '|', HEADER TRUE;
  2. ERROR: syntax error at or near "FORMAT"
  3. LINE 1: .../me/Documents/DATA/39079.txt' WITH FORMAT csv...
  4. ^
  5. temp=# show server_version;
  6. -[ RECORD 1 ]--+-----
  7. server_version | 10.1

从文档来看,这似乎是命令的有效语法。我做错了什么?
编辑:我在删除逗号后也尝试了这个方法,得到了相同的结果:

  1. temp=# COPY data_master FROM '/Users/me/Documents/DATA/39079.txt' WITH FORMAT CSV DELIMITER '|' HEADER TRUE;
  2. ERROR: syntax error at or near "FORMAT"
  3. LINE 1: .../me/Documents/DATA/39079.txt' WITH FORMAT CSV...
  4. ^
yrdbyhpb

yrdbyhpb1#

语法如下 WITH 应该在括号中。

  1. COPY data_master FROM '/Users/me/Documents/DATA/39079.txt'
  2. WITH (
  3. FORMAT csv,
  4. DELIMITER '|',
  5. HEADER TRUE
  6. );

相关问题