Hi All, Due to some security issues, we need to separate the data for one customer into a separate PostgreSQL box/server.
My question is that how could we have sql statements which allow us to access multiple PostgreSQL databases at the same time. Not separate schema, but in different postgresql server. Is there a way to SELECT tables or create JOINs from multiple databases JDBC or psql . I aware that Oracle has Database Link concept. Any tip will help. I did some search on previous posting, but cannot find much. Louie Kwan > NUVO - THE IT OUT-TASKING COMPANY > (613) 726-5071 Direct Line > (613) 721-1399 Fax > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster