Re: Dumb postgresql questions
On Mon, Nov 05, 2001 at 21:43:13 -0600, Corey Halpin wrote:
> 1. Is there some simple way to convert a mysql database into a postgresql
> database?
There are various ways. For a simple database, dump it, try to import it,
fix problems by hand, try again etc. There are also conversion utilities for
MySQL dumps, like my2pg.pl (http://ziet.zhitomir.ua/~fonin/code/ according
to a README in the postgresql-contrib package). In some cases (in particular
ones where you need to do some kind of cleanup) a custom Perl script using
DBI can be the best way.
HTH,
Ray
--
Outlook Express is free, and also sometimes lets strangers share your hard
disk - is this anarchism?
The Register's Graham Lea commenting on Steve Balmer's comparison of
Linux to communism in http://www.theregister.co.uk/content/1/12266.html
Reply to: