Re: request for help with COPY syntax - Mailing list pgsql-sql

From Fernando Hevia
Subject Re: request for help with COPY syntax
Date
Msg-id 02ab01c81594$07f63c20$8f01010a@iptel.com.ar
Whole thread Raw
In response to request for help with COPY syntax  ("Chuck D." <pgsql-list@nullmx.com>)
Responses Re: request for help with COPY syntax
List pgsql-sql
> -----Mensaje original-----
> De: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.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




pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: request for help with COPY syntax
Next
From: Paul Lambert
Date:
Subject: Quick question re foreign keys.