Using other database tables in a query

Started by Paul Greenover 24 years ago3 messagesgeneral
Jump to latest
#1Paul Green
lists@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!

#2steve boyle
boylesa@dial.pipex.com
In reply to: Paul Green (#1)
Re: Using other database tables in a query

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

#3Paul Green
paul@webleicester.net
In reply to: Paul Green (#1)
Re: Using other database tables in a query

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)