[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] importing tables from Oracle
From: John Callahan <john.callahan () udel ! edu>
Date: 2013-06-24 22:41:55
Message-ID: CAL=axXno8SjTg0Gn0omY3T69hkYErgqZbx00wzOEN25b53zsFw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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.callahan@udel.edu
On Mon, Jun 24, 2013 at 5:09 PM, dustymugs <dustymugs@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.callahan@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
>
[Attachment #5 (text/html)]
<div dir="ltr">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.<div> <br></div><div class="gmail_extra"><br clear="all"><div><div>- \
John</div><div><br></div><div><br></div><div>John Callahan</div><div>Research \
Scientist</div><div>Delaware Geological Survey</div><div>University of Delaware<br> \
<a href="http://www.dgs.udel.edu" \
target="_blank">http://www.dgs.udel.edu</a><br><div><a \
href="mailto:john.callahan@udel.edu" target="_blank">john.callahan@udel.edu</a> \
</div><br></div></div> <br><br><div class="gmail_quote">On Mon, Jun 24, 2013 at 5:09 \
PM, dustymugs <span dir="ltr"><<a href="mailto:dustymugs@gmail.com" \
target="_blank">dustymugs@gmail.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Assuming you have a recent version of PostgreSQL, you might \
be able to<br> try the foreign data wrapper for Oracle.<br>
<br>
<a href="http://wiki.postgresql.org/wiki/Foreign_data_wrappers#oracle_fdw" \
target="_blank">http://wiki.postgresql.org/wiki/Foreign_data_wrappers#oracle_fdw</a><br>
<br>
-bborie<br>
<div><div class="h5"><br>
On 06/24/2013 02:07 PM, John Callahan wrote:<br>
> I know this is more of a Postgres question than PostGIS...<br>
><br>
> I want to import some tables from our primary Oracle database into a<br>
> Postgres 9 database on a regular basis, probably weekly. Once in Postgres,<br>
> I have some scripts that create spatial objects, create indexes, and the<br>
> tables are then using in GeoServer and desktop GIS.<br>
><br>
> Are there any preferred methods to get tables from Oracle to Postgres?<br>
> dblink seems to be only for other Postgres databases. The Perl package<br>
> Ora2pg seems like an option but haven't heard of it before today. A \
simply<br> > brute force method could to be write a simple program to extract the \
oracle<br> > tables into CSV files and then run postgres COPY to ingest the files. \
Not<br> > very elegant but should work. Thanks.<br>
><br>
> - John<br>
><br>
><br>
> John Callahan<br>
> Research Scientist<br>
> Delaware Geological Survey<br>
> University of Delaware<br>
> <a href="http://www.dgs.udel.edu" \
target="_blank">http://www.dgs.udel.edu</a><br> > <a \
href="mailto:john.callahan@udel.edu">john.callahan@udel.edu</a><br> ><br>
><br>
><br>
</div></div>> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
><br> _______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
</blockquote></div><br></div></div>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic