"John Smith" <jayzee(dot)smith(at)gmail(dot)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