Re: Accessing different databases in a cluster

From: Naomi Walker <nwalker(at)eldocomp(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, Dave Blasby <dblasby(at)refractions(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Accessing different databases in a cluster
Date: 2001-08-01 20:12:14
Message-ID: 4.2.2.20010801131036.00ac9980@logic1design.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-08-01 20:14:26 Re: OID wraparound: summary and proposal
Previous Message Dave Cramer 2001-08-01 20:11:44 RE: What needs to be done?