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
