Re: select between two databases

The best way is to use /contrib/dblink in the source tree. In 7.3, you
can even return tables, not just single variables.

---------------------------------------------------------------------------

a(dot)hitter(at)hmd-software(dot)com wrote:
> Dear Support,
>
> I don't know how I can select between two databases on the same postgres-server? Does postgres support it? I have tested some ways but none of them was right:
>
> SELECT s.adresscode FROM db02.adressen a,sachbearbeiter s WHERE a.adresscode=s.adresscode
> Error message: Namespace "db02" does not exist
>
> SELECT '' FROM db02.adressen
> Error message: Namespace "db02" does not exist
>
> Thanks a lot in Advance
> Andreas Hitter
> hmd-software AG
> Munich - Germany
>
> To: pgsql-odbc(at)postgresql(dot)org
> inoue(at)postgresql(dot)org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073