"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 [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco