Thread: Distributed join query ?

Distributed join query ?

From
snpe
Date:
Hello,

Can I join tables in more databases in Postgresql ?

Re: Distributed join query ?

From
"Richard Huxton"
Date:
From: "snpe" <snpe@infosky.net>

> Hello,
>
> Can I join tables in more databases in Postgresql ?

If you mean join database1.tableA to database2.tableB I'm afraid not. Full
schema support is intended but I don't know when.

- Richard Huxton


Synonym

From
snpe
Date:
Hello,
    Can I created synonym for tables,views,functions ... in postgresql ?

Re: Synonym

From
will trillich
Date:
On Fri, May 11, 2001 at 02:04:18PM +0200, snpe wrote:
> Hello,
>     Can I created synonym for tables,views,functions ... in postgresql ?

well you can create a view which simulates a table:

    create view clone as
        select * from originaltable;

but that may not be what you're after.

--
don't visit this page. it's bad for you. take my expert word for it.
http://www.salon.com/people/col/pagl/2001/03/21/spring/index1.html

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!