Postgres does not natively do cross joins, you can however use a
third party tool called dblink From:
pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On
Behalf Of Little, Douglas 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 orbitz.com
| ebookers.com
| hotelclub.com |
cheaptickets.com
| ratestogo.com |
asiahotels.com |