Re: postgres gurus.

> > i have 2 databases on the same postgres installation and need to join the > > results from a table in each database .. i would expcet something like > > why cant the tables be in the same database? > afaik this isnt possible with pg... We wrote a db based web site.. so we had a db.. then all the sudden the requirements became that we had to handle N identically shaped sites on the same machine.. the first thing that popped to my mind is virtualizing the DB name and to have identical tables in different DB names.. works great until you have to do a search engine which searches in all the sites (DBs at this point) .. this would require a query that collects data from different databases or to do it all in PHP.. i have done it but ran into other major problems (See the general PHP leak under the thread "Huge Memory Leak") Giovanni Tummarello tummarel@ascu.unian.it Fight Spam! Join CAUCE (Coalition Against Unsolicited Commercial Email) at http://www.cauce.org/ and tell your Congresspeople how Spam mailings hurt you. Help protect genuine Internet commerce: Outlaw UCE Spamming.