Postgresql \COPY command and quote-less file

Question

Is there anyway to disable QUOTE AS this data distributor is giving out a file that has a set up like,

col1,col2
foo,bar

Some columns are a little more complex

col1,col2
Test outside-"bar' Blah blah` Someone else,What

Now the question: Is there a better way than giving QUOTE AS a character that is assumed not to exist?

\COPY maxmind.country FROM worldcitiespop.txt CSV QUOTE AS '$' HEADER

Where $ is an assumption the character doesn't exist?

Tobu · Accepted Answer · 2012-01-03 23:19:55Z

1

You don't need to know that the quote character doesn't exist, csv formats can escape quotes if necessary. You should just pick the appropriate dialect for what worldcitiespop.txt contains.

answered Jan 3, 2012 at 23:19

Tobu

25.6k4 gold badges94 silver badges100 bronze badges

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

1 Comment

Evan Carroll Over a year ago

There is no quote character though, it's just comma separated, i.e., commas can not occur in the data all possible quote characters can.

Collectives™ on Stack Overflow

Postgresql \COPY command and quote-less file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related