[postgis-users] importing tables from Oracle

[John Callahan]

I know this is more of a Postgres question than PostGIS...

I want to import some tables from our primary Oracle database into a
Postgres 9 database on a regular basis, probably weekly.  Once in Postgres,
I have some scripts that create spatial objects, create indexes, and the
tables are then using in GeoServer and desktop GIS.

Are there any preferred methods to get tables from Oracle to Postgres?
 dblink seems to be only for other Postgres databases.  The Perl package
Ora2pg seems like an option but haven't heard of it before today.  A simply
brute force method could to be write a simple program to extract the oracle
tables into CSV files and then run postgres COPY to ingest the files.  Not
very elegant but should work.  Thanks.

- John


John Callahan
Research Scientist
Delaware Geological Survey
University of Delaware
http://www.dgs.udel.edu
john.callahan at udel.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130624/5997f9a0/attachment.html>