Running queries from different databases and joining them

From: Robert(dot)Farrugia(at)go(dot)com(dot)mt
To: pgsql-admin(at)postgresql(dot)org
Subject: Running queries from different databases and joining them
Date: 2002-03-06 07:26:57
Message-ID: 20020306072643.6CB964758DC@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Does anyone know if the feature to do same queries on different databases
and then join them (just like the union in SQL) exists in Postgres ?

I know that one way of doing this is to use JDBC, do different queries and
join them manually. This is problematic for ordering and grouping since it
needs to be done manually for each query. Is there any other elegant way
of doing this ?

Regards
Robert

Browse pgsql-admin by date

  From Date Subject
Next Message Robert.Farrugia 2002-03-06 08:57:48 VACUUM in 7.2
Previous Message Linda Fousek 2002-03-06 00:21:19 FATAL ERROR: database does not exist in the system catalog