Querying across databases - Mailing list pgsql-general

From Zak McGregor
Subject Querying across databases
Date
Msg-id Pine.LNX.4.10.10010161316240.1312-100000@zak.home.co.za
Whole thread Raw
List pgsql-general
Hi all

Does anyone know if  there any way that I can combine tables from 2
databases into one query, or otherwise duplicate the contents (read-only
is fine) of a table in another database? All the databases are on the same
machine and being connected to from localhost.

Any help at all would be very much appreciated.

Thanks

====================================================================
Zak McGregor
--------------------------------------------------------------------
Of course my password is the same as my pet's name.
My macaw's name was Q47pY!3, but I change it every 90 days.
====================================================================


pgsql-general by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: int8 vs text in odbc link
Next
From: Andrew Gould
Date:
Subject: Re: Querying across databases