Postgres Pro
Downloads
Home   >   mailing lists

Cross-database queries - Mailing list pgsql-general

From Andy Hallam
Subject Cross-database queries
Date
Msg-id 9qovtv$1f3k$1@news.tht.net
Whole thread Raw
Responses Re: Cross-database queries  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
List pgsql-general
Tree view 
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@exel.co.uk

pgsql-general by date:

Previous
From: yeskw.bbs@rh1.yeskw.com (cocl)
Date:
Subject: Is the postmaster running (with -i) at 'localhost
Next
From: "Eric Sawler"
Date:
Subject: Re: RPM postmaster -i ?