Re: Cross database queries

From: Richard Huxton <dev(at)archonet(dot)com>
To: postgresql(at)bryden(dot)co(dot)za
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cross database queries
Date: 2005-08-09 14:47:56
Message-ID: 42F8C21C.2050302@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

postgresql(at)bryden(dot)co(dot)za wrote:
> Hi
>
> Suppose I have two databases on one server (lets call them DB_A and DB_B)
> and I was to write a cross database query. How do I do this in PostgreSQL?

Either use the dblink module from contrib/ or merge them into one
database but different schemas.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-08-09 14:49:58 Re: Database syncronization
Previous Message Jeff Boes 2005-08-09 14:45:52 Reference new.* or old.* in dynamic statement?