PostgreSQL COPY command with multiple FORCE_QUOTE columns

Question

I'm trying to export a table to CSV and force quoting of two columns.

I've tried the following command:

COPY hotel_position_daily TO '/home/ubuntu/export/hotel_position_daily.csv' CSV HEADER FORCE_QUOTE hotelname, city;

which resulted in

ERROR:  syntax error at or near "FORCE_QUOTE"
LINE 1: ...buntu/export/hotel_position_daily.csv' CSV HEADER FORCE_QUOT...

and I've tried

COPY hotel_position_daily TO '/home/ubuntu/export/hotel_position_daily.csv' WITH (FORMAT CSV, HEADER, FORCE_QUOTE hotelname, city);

which resulted in

ERROR:  argument to option "force_quote" must be a list of column names

what am I doing wrong?

Zoltán · Accepted Answer · 2015-07-03 10:47:54Z

23

I found the solution to be

COPY hotel_position_daily TO '/home/ubuntu/export/hotel_position_daily.csv' WITH (FORMAT CSV, HEADER, FORCE_QUOTE(hotelname, city));

answered Jul 3, 2015 at 10:47

Zoltán

22.3k15 gold badges96 silver badges140 bronze badges

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

2 Comments

venkat Over a year ago

this gives same error

psql -U postgres -d postgres -t -A -F"," -c "COPY (SELECT * FROM solrmaster) to '/tmp/solrmastertest.csv' DELIMITER '|' QUOTE '\"' FORCE_QUOTE {(key, components, docnum)} CSV HEADER"

kevlarr Over a year ago

Great answer, the first I'd seen that used with (...) - I didn't realize it needed parentheses around multiple, since ... with delimiter ',' worked without parens

Collectives™ on Stack Overflow

PostgreSQL COPY command with multiple FORCE_QUOTE columns

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related