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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
