Load PostgreSQL table from CSV with data with commas between brackets

Question

I've been given some CSV data I need to load into a PostgreSQL table with the following format:

7227, {text with, commas}, 10.0, 3.0, text with no commas

I want my table rows to appear as:

   7227 | text with, commas | 10.0 | 3.0 | text with no commas

How can I use COPY and get it to ignore commas between the brackets?

I'm trying to avoid pre-processing the file, although that is an option.

klin · Accepted Answer · 2015-05-21 19:02:59Z

2

I'm afraid you'll have to edit the file. This format should be ok:

7227, "text with, commas", 10.0, 3.0, text with no commas

Alternatively

7227, text with\, commas, 10.0, 3.0, text with no commas

according to this principle in the documentation:

Backslash characters (\) can be used in the COPY data to quote data characters that might otherwise be taken as row or column delimiters. In particular, the following characters must be preceded by a backslash if they appear as part of a column value: backslash itself, newline, carriage return, and the current delimiter character.

edited May 21, 2015 at 19:02

answered May 21, 2015 at 17:07

klin

123k15 gold badges241 silver badges263 bronze badges

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

Collectives™ on Stack Overflow

Load PostgreSQL table from CSV with data with commas between brackets

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related