Running queries from different databases and joining them - Mailing list pgsql-admin

From Robert.Farrugia@go.com.mt
Subject Running queries from different databases and joining them
Date
Msg-id 20020306072643.6CB964758DC@postgresql.org
Whole thread Raw
List 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


pgsql-admin by date:

Previous
From: lfousek@v2group.com (Linda Fousek)
Date:
Subject: FATAL ERROR: database does not exist in the system catalog
Next
From: Robert.Farrugia@go.com.mt
Date:
Subject: VACUUM in 7.2