| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Doug Silver <dsilver(at)urchin(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: errors using COPY from MySQL data |
| Date: | 2003-04-02 23:12:45 |
| Message-ID: | 200304021512.45999.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ulli Mueckstein | 2003-04-03 11:31:18 | call analyze from stored procedure in C |
| Previous Message | Tom Lane | 2003-04-02 20:48:02 | Re: Timestamp with time zone change (error) in 7.3.2? |