I'm moving an Oracle db to Postgres, primarily because the database isn't going to get large enough to warrant the high price of Oracle and our little startup is strapped for cash.
I'm hoping I can just change the type names mostly. The mapping I've come up with so far is:
VARCHAR2 to varchar
NUMBER(9) (used for primary keys it seems) to int8
LONG RAW (used to store binary files in the db) to bytea
DATE to timestamp
BLOB to bytea
NUMBER (no precision) to numeric
NUMBER (1-8) to int4
See any problems?
Access is via JDBC and they use tablespaces as namespaces - ie there is a copy of the schema in variously named tablespaces and access is always via TableSpace.TableName. What is the equivalent construct in Postgres? Is it schema?
Thanks for any help.