| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | yek ching <ynching(at)hotmail(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: pgsql multi-database queries |
| Date: | 2004-04-10 01:23:51 |
| Message-ID: | Pine.LNX.4.33.0404091923380.14175-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2004-04-10 01:28:08 | Re: Counting rows from two tables in one query |
| Previous Message | Bruce Momjian | 2004-04-10 01:06:48 | Re: Crypt() encryption |