pgsql help!!

[Anon]

Is there any way i can migrate from oracle database to pgsql?

[toma42]

I'm sure you can. Feel free to use my
mysql > pgsql code. You'll just need to change the datamaps and datatypes, I believe. Be warned, this code isn't for the faint of heart:

http://db.etree.org/wddx/mysql-psql.phps

[toma42]

Actually, what you'll really need to change is
1. how the tables are described (change from mysql way to oracle way)
2. how the columns are described
3. what datatypes map to pgsql types