Postgres COPY command with literal delimiter

Question

I was trying to import a CSV file into a PostgreSQL table using the COPY command. The delimiter of the CSV file is comma (,). However, there's also a text field with a comma in the value. For example:

COPY schema.table from '/folder/foo.csv' delimiter ',' CSV header

Here's the content of the foo.csv file:

Name,Description,Age
John,Male\,Tall,30

How to distinguish between the literal comma and the delimiter?

Thanks for your help.

The problem is that that's not really CSV. CSV expects delimiter characters to be quoted, and normal CSV doesn't allow for escaping delimiters. See Clodoaldo's answer. — Craig Ringer
– Craig Ringer, Commented Oct 2, 2014 at 15:42

Clodoaldo Neto · Accepted Answer · 2014-10-02 12:46:15Z

5

To have the \ to be recognized as a escape character it is necessary to use the text format

COPY schema.table from '/folder/foo.csv' delimiter ',' TEXT

But then it is also necessary to delete the first line as the HEADER option is only valid for the CSV format.

answered Oct 2, 2014 at 12:46

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

Postgres COPY command with literal delimiter

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related