Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1801E9FC641 for ; Tue, 23 Oct 2007 13:58:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 38719-05 for ; Tue, 23 Oct 2007 13:58:27 -0300 (ADT) X-Greylist: delayed 00:13:52.673547 by SQLgrey-1.7.5 Received: from pyxis.powervt.com.ar (host3.powervt.com.ar [200.43.63.66]) by postgresql.org (Postfix) with ESMTP id CA5F09FC0FE for ; Tue, 23 Oct 2007 13:58:27 -0300 (ADT) Received: from pcfhevia ([201.216.249.98]) by pyxis.powervt.com.ar (IPGroup Mail Server) with ESMTP id 1OT48953; Tue, 23 Oct 2007 13:44:32 -0300 From: "Fernando Hevia" To: , Subject: Re: request for help with COPY syntax Date: Tue, 23 Oct 2007 13:44:51 -0300 Organization: IP-TEL Message-ID: <02ab01c81594$07f63c20$8f01010a@iptel.com.ar> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcgVkWZAgB28nuS1Sqi7MgvUr7gSmgAAfBcw X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 In-Reply-To: <200710231019.07833.pgsql-list@nullmx.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/92 X-Sequence-Number: 29464 > -----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