Dblink and connections to MySQL?

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

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

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/

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