exporting table for load into oracle

From: miguel angel rojas aquino <mrojasaquino(at)yahoo(dot)com(dot)mx>
To: pgsql-general(at)postgresql(dot)org
Subject: exporting table for load into oracle
Date: 2005-02-26 23:25:09
Message-ID: 42210555.8090707@yahoo.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2005-02-27 02:12:54 Re: postgresql 8.0 advantages
Previous Message Mike Rylander 2005-02-26 22:33:13 Re: Backupping the table values