Thread: postgres 2 other databases

A while ago I heard about a postgres addon that would allow a postgres
database to treat tables in any other database as part of its own schema.

The way I understood it,  I could update a table in MySQL database
by issueing a "SELECT * INTO mysql_table FROM psql_table" command under
postgres.

Unfortunatly I've lost the notes I made about it and my Googlefu has
proven is too weak to find it.

.
.
.

Or I may have dreamed it.

Does this ring any bells?

--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD            Tel:44-1223 492626
Bioinformatician
HUGO Gene Nomenclature Committee    Email: hgnc@genenames.org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

On Jan 31, 2008 8:16 AM, Michael Lush <mjlush@ebi.ac.uk> wrote:
>
> A while ago I heard about a postgres addon that would allow a postgres
> database to treat tables in any other database as part of its own schema.
>
> The way I understood it,  I could update a table in MySQL database
> by issueing a "SELECT * INTO mysql_table FROM psql_table" command under
> postgres.
>
> Unfortunatly I've lost the notes I made about it and my Googlefu has
> proven is too weak to find it.

http://pgfoundry.org/projects/dbi-link/

Sean