[Ruby] Converting mysql to postgres
Joe Van Dyk
joevandyk at gmail.com
Sat Aug 5 01:22:05 PDT 2006
Hi,
Anyone got any cool tricks for converting a Rails site (in this case,
a typo installation) from a mysql database to a postgresql database?
I've got it almost working -- I'm doing a SQL dump from mysql and
loading it into postgres. However, mysql does booleans as a tinyint
with 0 = false and 1 = true. When I try to import that into a
postgres database that expects booleans to be actual booleans, it
fails.
Any ideas?
Thanks,
Joe
More information about the Ruby
mailing list