Cross-database queries

From: "Andy Hallam" <ahm(at)exel(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Cross-database queries
Date: 2001-10-19 10:38:44
Message-ID: 9qovtv$1f3k$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am porting our applications from SQL SERVER, ORACLE and DB2 to PostgreSQL.

I have just read that PostgreSQL does NOT support cross-database queries.

Please, please, please tell me this is incorrect.

I.e - I need to do something like:

SELECT data1, data2
FROM customerdb.a a, masterdb.b b
WHERE a.ref = b.ref

Can anyone confirm this is the case.

Andy
ahm(at)exel(dot)co(dot)uk

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jochem van Dieten 2001-10-19 11:26:27 Re: To Postgres Devs : Wouldn't changing the select limit
Previous Message cocl 2001-10-19 08:54:33 Is the postmaster running (with -i) at 'localhost