problems with copy - Mailing list pgsql-sql

From chester c young
Subject problems with copy
Date
Msg-id 660727.9191.qm@web54304.mail.re2.yahoo.com
Whole thread Raw
Responses Re: problems with copy
List pgsql-sql
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
 



pgsql-sql by date:

Previous
From: Erik Jones
Date:
Subject: Re: Many databases
Next
From: "Ashish Karalkar"
Date:
Subject: Re: foreign key problem