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@gmail.com 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/