select between two databases

From: <a(dot)hitter(at)hmd-software(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>, <inoue(at)postgresql(dot)org>
Subject: select between two databases
Date: 2003-05-27 07:38:58
Message-ID: DIIE.0000118E00074AE8@hmd-software.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Corrado Cavallini 2003-05-27 16:39:29 ODBC 07.03.0100 Incorrect mapping of Int8 fields in Access
Previous Message John K. Herreshoff 2003-05-26 21:16:36 odbc - ssl: how-to-do-it.