Using other database tables in a query
Hi,
Is there a way to use tables from other postgres databases (on the same
system) within queries? I've looked through the docs, but I haven't
found any mention of this. Is it me not looking hard enough or is it
just not possible? [:)]
Cheers!
Paul,
have a quick look for tablespaces / schemas on the web. Currently I don't
think this functionity is implemented but there's been a fair amount of
discussion re adding in the functionality. Its on the ToDo list
http://developer.postgresql.org/todo.php.
HIH
"Paul Green" <lists@webleicester.co.uk> wrote in message
news:3BD6CE78.7070104@webleicester.co.uk...
Show quoted text
Hi,
Is there a way to use tables from other postgres databases (on the same
system) within queries? I've looked through the docs, but I haven't
found any mention of this. Is it me not looking hard enough or is it
just not possible? [:)]Cheers!
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Ah, ok thanks. As this is urgent, I guess it'll be in a release fairly
soon? Back to the drawing board for now... :)
Paul
steve boyle wrote:
Paul,
have a quick look for tablespaces / schemas on the web. Currently I don't
think this functionity is implemented but there's been a fair amount of
discussion re adding in the functionality. Its on the ToDo list
http://developer.postgresql.org/todo.php.HIH
"Paul Green" <lists@webleicester.co.uk> wrote in message
news:3BD6CE78.7070104@webleicester.co.uk...Hi,
Is there a way to use tables from other postgres databases (on the same
system) within queries? I've looked through the docs, but I haven't
found any mention of this. Is it me not looking hard enough or is it
just not possible? [:)]Cheers!
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Paul Green
Programmer
Jippii Midlands
85 London Road,
Leicester,
England,
LE2 0PF.
tel: 0116 2521132 (direct)