Thread: Distributed join query ?

Distributed join query ?

From

snpe

Date:

10 May 2001, 14:36:47

Hello,

Can I join tables in more databases in Postgresql ?

Re: Distributed join query ?

From

"Richard Huxton"

Date:

10 May 2001, 22:22:53

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:

11 May 2001, 11:56:29

Hello,
    Can I created synonym for tables,views,functions ... in postgresql ?

Re: Synonym

From

will trillich

Date:

11 May 2001, 21:19:21

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!