Re: errors using COPY from MySQL data

Doug,

> I'm sure this has been covered before, but I'm quickly getting frustrated
> copying 100 lines at a time.  I did a data dump from a MySQL table, one of
> the fields is a timestamp which it output as '20020816:23:44', so I changed
> it to '20020816 23:44'.  But, I'm now consistently getting this error:

Hey, we can't help it if mysqldump's data formatting sucks.  :-(

Fortunately, there is hope:
http://docman.sourceforge.net/home_html/projects/sql/mysql2pgsql
Also see Techdocs (http://techdocs.postgresql.org) for additional
MySQL-to-Postgres help & tips.


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco