Re: request for help with COPY syntax

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: <pgsql-list(at)nullmx(dot)com>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: request for help with COPY syntax
Date: 2007-10-23 16:44:51
Message-ID: 02ab01c81594$07f63c20$8f01010a@iptel.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> -----Mensaje original-----
> De: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org]
> En nombre de Chuck D.
>

> Anyone known how I can rewrite the COPY command to allow those " or '
> within
> the data? After a couple days I wasn't able to find any examples to help.
>

Hi Chuck,
Do you need those characters in your table? If not I think you will be
better off preprocessing the data before running copy.

Replacing those " for ' or directly removing them is quite simple if you are
working in Unix, actually it should be quite simple in any operating system.

Regards,
Fernando

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-10-23 16:46:38 Re: request for help with COPY syntax
Previous Message Chuck D. 2007-10-23 16:19:07 request for help with COPY syntax