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
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 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