Thread: Using other database tables in a query

Using other database tables in a query

From
Paul Green
Date:
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!

Re: Using other database tables in a query

From
"steve boyle"
Date:
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



Re: Using other database tables in a query

From
Paul Green
Date:
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)