Re: Cross database queries - Mailing list pgsql-general

From Richard Huxton
Subject Re: Cross database queries
Date
Msg-id 42F8C21C.2050302@archonet.com
Whole thread Raw
In response to Cross database queries  (postgresql@bryden.co.za)
List pgsql-general
postgresql@bryden.co.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

pgsql-general by date:

Previous
From: Sean Davis
Date:
Subject: Re: best way to reference tables
Next
From: Tom Lane
Date:
Subject: Re: Case sensitivity