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