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