On Tue, 2007-01-09 at 19:54, garrettmoore@xxxxxxxxx wrote: > Hello, > > I am working on a project where we are converting from MySQL to > Postgres. I figured the easiest way would be to export the MySQL data > as CSV. > > I'm having a problem importing some of the data. What I have done is > exported the MySQL data and then modified it so that all single quotes > (a ' quote) are doubled, and null values are replaced with an empty > value in the CSV. > > Our data, for example, looks like this: > > 2628,'Poster,5,'255.255.18.138',,'[quote=gz]I''m curious, why not allow > users, then to freely edit topics?[/quote] > We could either go with "it''s a minor annoyance that is one measure > that helps keep DB load lower," or "we do it just to piss you off." > You choose.',0,1124498148,,,376,0,0,, If that is indeed the line, then this part: 2628,'Poster,5,'255.255.18.138', is misformed. I'm assuming you really need: 2628,'Poster',5,'255.255.18.138',
