Обсуждение: [UMN_MAPSERVER-USERS] query postgres AND oracle

guys,
i got geometry in postgres, some other data in oracle. is it possible
to filter postgres geometry based on oracle data (without using
services)?
cheers, jzs

On Jan 31, 2008 1:38 PM, John Smith <jayzee.smith@gmail.com> wrote:
> guys,
> i got geometry in postgres, some other data in oracle. is it possible
> to filter postgres geometry based on oracle data (without using
> services)?

You either import the data from oracle to pgsql and let the db do it
(fastest), use some form of dbilink to cross query to the oracle
database (slower), or you do it in the application (usually slowest)

My recommendation is to write some kind of simple script to import the
data from oracle and keep it up to date, especially if it's not real
high volume.

Explaining more about your particular problem will get better answers.

thanks. thought dbi-link could only connect across postgres databases,
didn't realize it can connect postgres AND oracle. will look into it.
jzs

On 1/31/08, Chander Ganesan <chander@otg-nc.com> wrote:
>
>  John Smith wrote:
>  guys,
> i got geometry in postgres, some other data in oracle. is it possible
> to filter postgres geometry based on oracle data (without using
> services)?
> cheers, jzs
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>  Have you looked at http://pgfoundry.org/projects/dbi-link/
> ?
>  --
> Chander Ganesan
> Open Technology Group, Inc.
> One Copley Parkway, Suite 210
> Morrisville, NC 27560
> Phone: 877-258-8987/919-463-0999
> http://www.otg-nc.com

"John Smith" <jayzee.smith@gmail.com> writes:
> thanks. thought dbi-link could only connect across postgres databases,
> didn't realize it can connect postgres AND oracle. will look into it.

No, you're confusing it with dblink, which is Postgres-specific.
dbi-link relies on the Perl DBI layer, so it should be able to talk
to anything for which you can find a DBD driver.  It's a completely
different programming model though, and doesn't expose as much
flexibility as dblink does.

            regards, tom lane