Select from multiple db's

From: Aaron Holtz <aholtz(at)bright(dot)net>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Select from multiple db's
Date: 1999-07-14 19:26:09
Message-ID: Pine.LNX.4.10.9907141523510.13183-100000@barbarossa.bright.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bright(dot)net
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gilles Darold 1999-07-14 19:46:40 Re: [GENERAL] Perl - Apache / Postgress
Previous Message Hub.Org News Admin 1999-07-14 13:03:10