hi everybody
first, it is not that i'm migrating from postgresql to oracle, it's just that we have a payroll system (we are a software development company) that currently runs on postgresql, but the goal is that it runs on other databases too (for our internal needs it runs on postgresql, and two of our clients run in postgresql too), so now i need to test it on oracle
i've done a dump of our data, but we are having troubles with the date fields, as pg_dump just dumps dates as 'yyyy-mm-dd', but when loading into oracle, it just can't handle dates this way, it needs an explicit mask (to_date....) when importing the sql dump
so the question is, there is a way to instruct pg_dump to dump dates with the to_date function included?
i've searched in the pg_dump docs, but didn't find any wat to achieve my goal
thanks in advance for your responses, and best wishes
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
