| From: | chester c young <chestercyoung(at)yahoo(dot)com> |
|---|---|
| To: | sql pgsql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | problems with copy |
| Date: | 2007-09-25 00:38:33 |
| Message-ID: | 660727.9191.qm@web54304.mail.re2.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alessandra Bilardi | 2007-09-25 17:28:34 | Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file] |
| Previous Message | Erik Jones | 2007-09-24 15:37:27 | Re: Many databases |