issue with delimiter in field during COPY

Hi,

Using COPY to bring data into a table. It uses "|" which i allow for with a
command such as:

COPY mydata FROM E'C:\\mydata\\mydata.txt' USING DELIMITERS '|'

This works fine except for a url field which randomly includes a pipeline
"|" character. Despite the url being in quotation (" ") marks, the field is
split in two resulting in an unexpected number of columns.

Looking at the data imported, i can see that the quotation marks seem to
have been imported as well rather than the content recognised as text.

Is there any way to force the system to recognise the quotation marks, the
info in postgres 9.0 documentation seems to suggest that it is only possible
to specify the quotation marks using 'quote' for CSV format (along with
specifying the header).

Any help much appreciated...

Andy

--
View this message in context: http://postgresql.1045698.n5.nabble.com/issue-with-delimiter-in-field-during-COPY-tp4990771p4990771.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.