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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match