From: | David Hartwig <daveh(at)insightdist(dot)com> |
---|---|
To: | Dirk Lutzebaeck <lutzeb(at)cs(dot)tu-berlin(dot)de> |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] SELECT across two databases |
Date: | 1998-05-27 16:34:37 |
Message-ID: | 356C409C.96D485C3@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
PostgreSQL does not support this feature at this time. And, I would not
expect it any time soon. You would have to either code such a join by
hand.
There is one other option. Many ODBC compliant tools will support
multi-data source joins. However this solution may perform poorly
because one side of the join may iteratively query one of the data
sources. Your call.
Irk Lutzebaeck wrote:
> hi,
>
> when I have two databases say db1 and db2 can there be a select
> statement which accesses both databases eg.
>
> select * from db1.t1,db2.t2 (which is illegal syntax in postgresql but
> legal in informix)
>
> Is there another way to select several databases/namespaces at once?
>
> Dirk
From | Date | Subject | |
---|---|---|---|
Next Message | Brett W. McCoy | 1998-05-27 17:48:11 | Re: [SQL] PDF of Programmer's Guide? |
Previous Message | Mark Pulver | 1998-05-27 16:07:23 | PDF of Programmer's Guide? |