Postgres does not natively do cross joins, you can however use a third party tool called dblink
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Little, Douglas
Sent: Thursday, October 28, 2010 8:35 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] advantages of multiple db's
Hi,
We have 1 db with everything in our entire enterprise in it (It’s a data warehouse). What are some of the disadvantages of using multiple db’s?
Can we join across db’s?
Doug Little
Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
Douglas.Little@orbitz.com
orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com