Hi fire-eyes, on Wednesday, 2006-08-02 at 10:07:43, you wrote: > It's about 12MB total, with I think 3 tables.
Unless you're planning on migrating other databases, this sounds like a
job best done by hand and/or a small perl script. mysqldump should spit
out something that can easily be converted to a form digestible by psql.
I did something like that for a tool that could only create
MySQL-specific SQL from an ER diagram, and getting it to PostgreSQL was
mainly some mapping of datatypes, like TINYINT to SMALLINT,
AUTO_INCREMENT to SERIAL UNIQUE and such.
cheers!
Matthias
--
I prefer encrypted and signed messages. KeyID: FAC37665
Fingerprint: 8C16 3F0A A6FC DF0D 19B0 8DEF 48D9 1700 FAC3 7665
pgpdQPI3xasRJ.pgp
Description: PGP signature
