On Thu, 8 Apr 2004, yek ching wrote:
> Dear Sir/Miss,
>
> Is there a way to do a multi-database select query??.. I fail to find the
> related solution... currently i i created seperate table call stockmaster
> under seperate database for each seperate organizations... When i want to
> queries out the stock item qty for multi database, i face a problem where
> sql only can work for single database..
>
> How can i use the same SQL statement in Pgsql??..
> "SELECT * FROM A.stockmaster,B.stockmaster where A.item=B.item"
Look in the contrib/dblink directory in the source tar ball.