Re: Accessing different databases in a cluster - Mailing list pgsql-hackers

From Naomi Walker
Subject Re: Accessing different databases in a cluster
Date
Msg-id 4.2.2.20010801131036.00ac9980@logic1design.com
Whole thread Raw
In response to Accessing different databases in a cluster  (Dave Blasby <dblasby@refractions.net>)
Responses Re: Accessing different databases in a cluster
List pgsql-hackers
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.



--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100  ext 242 



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: OID wraparound: summary and proposal
Next
From: Stephan Szabo
Date:
Subject: Re: Accessing different databases in a cluster