[Ruby] Converting mysql to postgres

James Moore banshee at banshee.com
Sat Aug 5 14:29:27 PDT 2006


What about just import them exactly as they are in mysql and then alter the
table to booleans using postgres tools?  Presumably it's an easy select
transformation if you're going postgres-to-postgres.

Something like 

select booleanfield > 0, anotherfield from thetableyouimportedfrommysql into
yournewtablename

With slightly less mangled sql syntax...

 - James




More information about the Ruby mailing list