"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