You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It seems having the same delimiter for columns and the elements of the array confuses the Postgres copy command.
One solution I found was to set the delimiter to something else, e.g. | and leave the delimiter for the array to be comma separated.
The text was updated successfully, but these errors were encountered:
A better solution is to simply quote the array:
E.g.
COPY mydb_3195.test_qm_import_fits (targetid,targetcode,fluxarray) FROM stdin CSV DELIMITER ',';
19722,ABCD,"{{24.82,5.42},{0.10,14.04}}"
75828,ABC,"{{514.06,60.03},{82.43,19.31}}"
It seems having the same delimiter for columns and the elements of the array confuses the Postgres copy command.
One solution I found was to set the delimiter to something else, e.g. | and leave the delimiter for the array to be comma separated.
The text was updated successfully, but these errors were encountered: