Select from multiple db's - Mailing list pgsql-general

From Aaron Holtz
Subject Select from multiple db's
Date
Msg-id Pine.LNX.4.10.9907141523510.13183-100000@barbarossa.bright.net
Whole thread Raw
Responses Re: [GENERAL] Select from multiple db's
List pgsql-general
Is it possible with postgres to do a select from tables contained in
separate databases?   I have two separate db's that are maintained, but
would like to make a select from one of them to insert the data into the
second one.  Any thoughts on how to make this work would be appreciated.
Merging the two db's won't be anything easy, so I'm looking for a way for
this type of query to be valid.

--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Specialist
Email:  aholtz@bright.net
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------



pgsql-general by date:

Previous
From: "Hub.Org News Admin"
Date:
Subject: ...
Next
From: Gilles Darold
Date:
Subject: Re: [GENERAL] Perl - Apache / Postgress