From: Chuck D. <pgsql-list@nullmx.com>
To: Fernando Hevia <fhevia@ip-tel.com.ar>
To: pgsql-sql@postgresql.org
Subject: Re: request for help with COPY syntax
Date: Wed, 24 Oct 2007 01:02:19 -0600
Message-ID: <200710240102.19224.pgsql-list@nullmx.com> (raw)
In-Reply-To: <02ab01c81594$07f63c20$8f01010a@iptel.com.ar>
References: <02ab01c81594$07f63c20$8f01010a@iptel.com.ar>
On October 23, 2007 10:44:51 am you wrote:
> 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
Greetings,
I'm not sure if they are needed because I've never seen a double quote in a
place name before. I don't believe they are errors though because there are
more records that contain them. As well, some records have single and double
quotes allowed within a record and this really messes things up.
Any ideas? Should I consider removing them in favor of a single quote? If
so, do you know how to do this with sed or similar?
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: pgsql-list@nullmx.com, fhevia@ip-tel.com.ar
Subject: Re: request for help with COPY syntax
In-Reply-To: <200710240102.19224.pgsql-list@nullmx.com>
* 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