I used csvsql to generate CREATE statements, and it looks like it assumed trimmed fields though the data has some spaces padding the field:
ERROR: value too long for type character varying(11) CONTEXT: COPY example, line 1314, column state: " South Korea"
I'm not entirely sure why the data has padding -- it definitely shouldn't but about half the values in the state column have some padding around them.
I could use
ALTER to make more space in the field, and then
UPDATE example SET state=trim(state); after I
COPY the csv in, I'm wondering if there's a clean way to just trim the padding as I import the data?