This looks ideal. I'll need to upgrade my software to support this but it should do exactly what I need. I'm still using Postgres 9.0/PostGIS 2.0 and will likely upgrade to PG 9.3/PostGIS 2.1 when they get released. Thanks.
- John John Callahan Research Scientist Delaware Geological Survey University of Delaware http://www.dgs.udel.edu john.calla...@udel.edu On Mon, Jun 24, 2013 at 5:09 PM, dustymugs <dustym...@gmail.com> wrote: > Assuming you have a recent version of PostgreSQL, you might be able to > try the foreign data wrapper for Oracle. > > http://wiki.postgresql.org/wiki/Foreign_data_wrappers#oracle_fdw > > -bborie > > On 06/24/2013 02:07 PM, John Callahan wrote: > > 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.calla...@udel.edu > > > > > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@lists.osgeo.org > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > postgis-users@lists.osgeo.org > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users