[Ruby] Converting mysql to postgres

[Eric Hodel]

On Aug 7, 2006, at 3:29 PM, Eric Hodel wrote:

> On Aug 5, 2006, at 1:22 AM, Joe Van Dyk wrote:
>
>> 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?
>
> As Ryan mentioned, I wrote this:

How odd, it was right here.

How about:

-------------- next part --------------

-- 
Eric Hodel - drbrain at segment7.net - http://blog.segment7.net
This implementation is HODEL-HASH-9600 compliant

http://trackmap.robotcoop.com