Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 405449FA181 for ; Mon, 24 Sep 2007 21:38:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 67040-05 for ; Mon, 24 Sep 2007 21:38:30 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54304.mail.re2.yahoo.com (web54304.mail.re2.yahoo.com [206.190.49.114]) by postgresql.org (Postfix) with SMTP id 8625A9FA144 for ; Mon, 24 Sep 2007 21:38:35 -0300 (ADT) Received: (qmail 10847 invoked by uid 60001); 25 Sep 2007 00:38:33 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Uvs11UsrzDmUoPA8b0rVO/eoLEt5Vtx+DUFWafuLcfNXoPpwmorqgim5L04e7JLeWThUpOpBbRBtN3cWxxyiFAbI1zaIB/baZ8xBePn1tI5xSNs7wD5EgmAHsCsbh5YZUI/+sHfIUOjqGuvMOv+TdKSDHpdTigdrLxHwwuFkb2M=; X-YMail-OSG: nsisz98VM1lQlvveV9RsNreJsbyQGRsNe5bEvgrT52ed7kgZBvFQtGYoYaIoCrHUkmoVupXgoc7q1tMoIVCcuWB8eGqrxzb7KUmLYMQrLmmAALFb5QKqOwgll.C_hA-- Received: from [69.229.238.138] by web54304.mail.re2.yahoo.com via HTTP; Mon, 24 Sep 2007 17:38:33 PDT Date: Mon, 24 Sep 2007 17:38:33 -0700 (PDT) From: chester c young Subject: problems with copy To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <660727.9191.qm@web54304.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/152 X-Sequence-Number: 29365 I'm getting lots of delimited files from Excel and MySQL users that, mid-file, begin truncating lines if ending in null values. for example: 1781: "one","two","three",,,,,, 1782: "one","two","three",, 1783: "one","two","three",, (delimited files from Open Office are well behaved) is there any way to handle this apparently standard aberration in PG? ____________________________________________________________________________________ Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel and lay it on us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7