Syntax error in COPY FROM thrown by postgres

Question

I'm trying to import data from a pipe-delimited text file into my Postgres data_master table. My command looks like this:

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

Here's the error:

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

From the docs this seems like a valid syntax for the command. What did I do wrong?

EDIT: I tried this after removing the commas as well, with the same results:

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

Thom Brown · Accepted Answer · 2020-05-21 17:47:28Z

2

The syntax following WITH should be in parentheses.

COPY data_master FROM '/Users/me/Documents/DATA/39079.txt' 
  WITH (
    FORMAT csv, 
    DELIMITER '|', 
    HEADER TRUE
  );

edited May 21, 2020 at 17:47

answered May 21, 2020 at 17:31

Thom Brown

2,0698 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error in COPY FROM thrown by postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related