Thread: Accessing different databases in a cluster
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? Ie. If I have two databases accessible from the same postmaster; one called db_one and the other called db_two. %psql -U postgres -p 5555 db_one db_one=# select * from db_two.mytable; ... or, from the other perspective; %psql -U postgres -p 5555 db_two db_two=# select * from db_one.myothertable; ... Thanks, dave
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.
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
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.