Re: problems with copy - Mailing list pgsql-sql

From Luis Carlos Ferreira
Subject Re: problems with copy
Date
Msg-id 200709281321.38410.lcf@tuxedo.com.ar
Whole thread Raw
In response to problems with copy  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
El Lun 24 Sep 2007 21:38, chester c young escribió:
> 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?
>
You need to normalize the csv files filtering its contents with some script
...
...
$fields_in_table=9;
while (<>) {chomp;@f=split(",");for $i ( 0 .. $fields_in_table ) {   print $f[$i].",";};print "\n";
};
...
...

--

Luis


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: to restore database in schema
Next
From: "Jon Horsman"
Date:
Subject: Populate unique column with default value