The missing quote after Poster is a mistake I made when sanitzing the data for posting here. That error is NOT present in the actual data. There is a quote where needed in the data. So, with that in mind, why am I still getting the error? Also, there is no symbol we can expect to not be in the data. This data is from several sources, including a message board, and there could be tildes, pipes, or any other symbol in discussion fields. Also since it's CSV we just have null represented by lack of any value between two commas, so: a,b,,d represents a row with values a, b, NULL, d. This works fine in general. Walter Vaughan wrote: > 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 dunno, but unless you don't really care about your data, I'd use something > that you have no chance of in your data. Things like | and ~ are pretty standard > field separators. > > So you'd use things like FIELDS TERMINATED BY '|' in your MySQL export > and WITH DELIMITER '|' NULL '' in your postgresql import > > Also remember that mySQL nulls are nothing like postgresql nulls. > > -- > Walter > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org/
