SQL Questions -> migrating MySQL to PostgreSQL?

Erik Norgaard norgaard at locolomo.org
Fri Feb 11 16:19:05 PST 2005


Peter Risdon wrote:
> Postgresql is an excellent dbms and well worth a look. But if you're
> starting out, I think mysql is the place to be.

Ok, since the discussion is up, I have used MySQL for years, no problem 
serves my needs. Yet, I'd like to try out that PostgreSQL so many talks 
about. So, how do I migrate?

I want to dump my mysql database - not big - and load it all into 
postgresql - of course it's perlable, but maybe there is an easier 
solution. Second, what do I need to change in my php scripts?

Thanks, Erik
-- 
Ph: +34.666334818                           web: http://www.locolomo.org
S/MIME Certificate: http://www.locolomo.org/crt/2004071206.crt
Subject ID:  A9:76:7A:ED:06:95:2B:8D:48:97:CE:F2:3F:42:C8:F2:22:DE:4C:B9
Fingerprint: 4A:E8:63:38:46:F6:9A:5D:B4:DC:29:41:3F:62:D3:0A:73:25:67:C2


More information about the freebsd-questions mailing list