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
> NUVO - THE IT OUT-TASKING COMPANY
> (613) 726-5071 Direct Line
> (613) 721-1399 Fax
pgsql-admin by date
|Next:||From: Andrew Sullivan||Date: 2004-03-24 20:19:10|
|Subject: Re: access multiple PostgreSQL Databases at the same time.|
|Previous:||From: Naomi Walker||Date: 2004-03-24 18:46:02|
|Subject: Re: [Retrieved]RE: backup and recovery|