Re: Accessing different databases in a cluster

On Wed, 1 Aug 2001, Naomi Walker wrote:

> At 12:22 PM 8/1/01 -0700, Stephan Szabo wrote:
> >On Wed, 1 Aug 2001, Dave Blasby wrote:
> >
> > > Is it possible to access tables in one database from another database if
> > > they're in the same cluster?  I dont seem to be able to do it; is there
> > > something I have to do or is it impossible?
> >
> >No, AFAIK, this isn't currently possible.
>
> Really, you cannot do a "select from" one and "insert into" another?
> 
> You could probably rig it up through pipes, like a pg_dump piped to a 
> pg_restore.

True, but you can't do it entirely within postgres without writing your
own functions.  You could do some kind of replication, but then you'd
really only be accessing tables inside one database, just ones that were
replicated from another.