From: Fernando Hevia <fhevia@ip-tel.com.ar>
To: pgsql-list@nullmx.com
To: pgsql-sql@postgresql.org
Subject: Re: request for help with COPY syntax
Date: Tue, 23 Oct 2007 13:44:51 -0300
Message-ID: <02ab01c81594$07f63c20$8f01010a@iptel.com.ar> (raw)
In-Reply-To: <200710231019.07833.pgsql-list@nullmx.com>
> -----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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fhevia@ip-tel.com.ar, pgsql-list@nullmx.com
Subject: Re: request for help with COPY syntax
In-Reply-To: <02ab01c81594$07f63c20$8f01010a@iptel.com.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox