pgsql multi-database queries

From: "yek ching" <ynching(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: pgsql multi-database queries
Date: 2004-04-08 07:52:00
Message-ID: BAY13-F19q5ijb1u2ZN0005147e@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message kumar 2004-04-08 09:32:07 Encoding and result string length
Previous Message Bruce Momjian 2004-04-08 00:25:25 Re: SQL Standatd