Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgsql multi-database queries

pgsql multi-database queries

From
"yek ching"
Date:
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/

Re: pgsql multi-database queries

From
"scott.marlowe"
Date:
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.