Postgres Pro
Downloads
Home   >   mailing lists

Re: how to select * from database1 table,database2 table - Mailing list pgsql-sql

From Josh Berkus
Subject Re: how to select * from database1 table,database2 table
Date
Msg-id 3A8AB351.F10690E0@agliodbs.com
Whole thread Raw
In response to how to select * from database1 table,database2 table  ("guard" <guard@ficnet.net>)
List pgsql-sql
Tree view 
"guard":

> if join database1 database2
> 
> how to make

Folks, this really needs to be on a FAQ somewhere:

PostgreSQL does not support inter-database Joins.  Period.

If you want to join tables from two different databases, I suggest that
you use your front-end code to do so.  I would also suggest that you
review your data architecture and see if it's really necessary for you
to store your data in two seperate databases.

-Josh Berkus

-- 
______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology      josh@agliodbs.com   and data management solutions       (415) 565-7293  for law firms, small
businesses      fax  621-2533   and non-profit organizations.       San Francisco

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to create a type ?
Next
From: Dave Wedwick
Date:
Subject: Re: Trigger question