Re: issue with delimiter in field during COPY

Thanks Adrian,

Apologies, i'd assumed specifying "CSV" would work just for actual CSV files
with comma separation.

Thanks again

Andy

From: Adrian Klaver-3 [via PostgreSQL]
[mailto:ml-node+s1045698n4990887h21(at)n5(dot)nabble(dot)com]
Sent: 14 November 2011 14:24
To: LPlateAndy
Subject: Re: issue with delimiter in field during COPY

On Monday, November 14, 2011 5:39:41 am LPlateAndy wrote:

> 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).

Yes, you will need to use CSV format to specify a quote character. No you do
not
have to specify a HEADER. The HEADER option is a toggle, if it is present
it
indicates that there is a header row. If it is not present than that
indicates
there is no header.

>
> Any help much appreciated...
>
> Andy
>
>
> --

--
Adrian Klaver
[hidden email]

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

_____

If you reply to this email, your message will be added to the discussion
below:

http://postgresql.1045698.n5.nabble.com/issue-with-delimiter-in-field-during
-COPY-tp4990771p4990887.html

To unsubscribe from issue with delimiter in field during COPY, click here
<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=unsu
bscribe_by_code&node=4990771&code=YW5keUBjZW50cmVtYXBzLmNvLnVrfDQ5OTA3NzF8LT
E3NDM2MTI2> .
See how NAML generates this email
<http://postgresql.1045698.n5.nabble.com/template/NamlServlet.jtp?macro=macr
o_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.B
asicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.templ
ate.InstantMailNamespace&breadcrumbs=instant+emails%21nabble%3Aemail.naml-in
stant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

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