Re: how to select * from database1 table,database2 table

"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 information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco