Postgres Pro
Downloads
Home   >   mailing lists

select between two databases - Mailing list pgsql-odbc

From
Subject select between two databases
Date
Msg-id DIIE.0000118E00074AE8@hmd-software.com
Whole thread Raw
Responses Re: select between two databases  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-odbc
Tree view
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@postgresql.org
    inoue@postgresql.org

pgsql-odbc by date:

Previous
From: Sébastien Dehesdin
Date:
Subject: Freezing with the EDB engine
Next
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: [INTERFACES] Large Objects