Home > mailing lists

Cross-database queries - Mailing list pgsql-general

From	Andy Hallam
Subject	Cross-database queries
Date	October 19, 2001 11:40:34
Msg-id	9qovtv$1f3k$1@news.tht.net Whole thread Raw
Responses	Re: Cross-database queries
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:

From: yeskw.bbs@rh1.yeskw.com (cocl)
Date: 19 October 2001, 11:34:00
Subject: Is the postmaster running (with -i) at 'localhost

From: "Eric Sawler"
Date: 19 October 2001, 11:40:50
Subject: Re: RPM postmaster -i ?

Cross-database queries - Mailing list pgsql-general

Previous

Next