Обсуждение: Dblink and connections to MySQL?

Brian Maguire wrote:
> Does anyone have any recommendations or experiences on connecting a
> postgres db to a mysql db possibly through dblink or another
> technology?  Does dblink just do postgres to postgres?  There is not a
> lot documentation on that contrib.

What brings you to that conclusion? dblink has more documentation than
most of the rest of the contrib modules. See README.dblink and
contrib/dblink/doc/*. Feel free to contribute more in areas you feel are
lacking...

But yes, dblink is only postgres-to-postgres. There are several spinoffs
that do postgres-to-other-rdbms located on gborg or pgfoundry.

Joe

Hi Brian,
Dblink is for postgresql to postgresql, you have to use DBI-Link for
connections to other databases.
http://pgfoundry.org/projects/dbi-link/

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration

On Wednesday 30 August 2006 15:41, Tony Caduto wrote:
> Hi Brian,
> Dblink is for postgresql to postgresql, you have to use DBI-Link for
> connections to other databases.
> http://pgfoundry.org/projects/dbi-link/

Note that you can use some of the pl functions themselves to accomplish this
as well, plphp for instance.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

Brian Maguire wrote:
> Does anyone have any recommendations or experiences on connecting a
> postgres db to a mysql db possibly through dblink or another technology?
> Does dblink just do postgres to postgres?  There is not a lot
> documentation on that contrib.

You could probably use DBIlink for that.. check pgfoundry.

SIncerely,

Joshua D. Drake


>
>
>
> Thanks,
>
> Brian
>
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/