On 1/11/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
Merlin Moncure wrote:
> On 1/10/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Le mercredi 10 janvier 2007 02:54, [EMAIL PROTECTED] a ?crit:
> > > 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.
>
> If you are using pg 8.2+, I've had good luck with the following:
>
> 1. create pgsql schema by hand or using some method, so they match mysql
> 2. mysqldump --compatible=postgresql [yadda] | grep ^INSERT | psql [yadda]
Wow, mysqldump has a postgresql compatibility mode? Intersting.
It does (had it for years), but it doesn't do very much...fixes the
quotes and a couple of other things. In particular I know of no easy
ways to convert the table schemas without use of external tools.
merlin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
