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