[EMAIL PROTECTED] wrote:
Hi
Suppose I have two databases on one server (lets call them DB_A and DB_B)
and I was to write a cross database query. How do I do this in PostgreSQL?
Either use the dblink module from contrib/ or merge them into one
database but different schemas.
--
Richard Hux
On 8/9/05 10:21 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> Hi
>
> Suppose I have two databases on one server (lets call them DB_A and DB_B)
> and I was to write a cross database query. How do I do this in PostgreSQL?
>
> On MS-SQL I would do something like:
>
> SELECT ta.Field1, ta.Fi
Hi
Suppose I have two databases on one server (lets call them DB_A and DB_B)
and I was to write a cross database query. How do I do this in PostgreSQL?
On MS-SQL I would do something like:
SELECT ta.Field1, ta.Field2, tb.Field2
FROM DB_A.dbo.SomeTable ta
JOIN DB_B.dbo.SomeOtherTable tb
ON ta.F
On Fri, 19 Oct 2001, Andy Hallam wrote:
> I am porting our applications from SQL SERVER, ORACLE and DB2 to PostgreSQL.
>
> I have just read that PostgreSQL does NOT support cross-database queries.
Nope, it doesn't. However, you can simulate this in your client
application by having two database
