pgsql multi-database queries - Mailing list pgsql-sql

From yek ching
Subject pgsql multi-database queries
Date
Msg-id BAY13-F19q5ijb1u2ZN0005147e@hotmail.com
Whole thread Raw
Responses Re: pgsql multi-database queries  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-sql
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"

Regards,
Ching

_________________________________________________________________
Are you in love? Find a date on MSN Personals http://match.msn.com.my/



pgsql-sql by date:

Previous
From: reina_ga@hotmail.com (Tony Reina)
Date:
Subject: Re: Help with COPY command
Next
From: "Rajeev Chaudhary, Noida"
Date:
Subject: hi sir urgent..required a Query