From: yek ching <ynching@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: pgsql multi-database queries
Date: Thu, 08 Apr 2004 07:52:00 +0000
Message-ID: <BAY13-F19q5ijb1u2ZN0005147e@hotmail.com> (raw)
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ynching@hotmail.com
Subject: Re: pgsql multi-database queries
In-Reply-To: <BAY13-F19q5ijb1u2ZN0005147e@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox