From: | Indraneel Majumdar <indraneel(at)www(dot)cdfd(dot)org(dot)in> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Select between two databases |
Date: | 2000-09-25 00:37:53 |
Message-ID: | Pine.SGI.3.96.1000924171306.91135C-100000@www.cdfd.org.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
Does any one know how I may select between two databases running on same
machine or on different machines eg.
select colA1 from tableA1 where colA2 in (select colB1 from tableB1);
here tableA1 and tableB1 are in different databases. The two databases
might be under the same postmaster or on different machines under
different postmasters. How do I query both simultaneously? Is it possible?
Thanks,
Indraneel
/************************************************************************.
# Indraneel Majumdar ¡ E-mail: indraneel(at)123india(dot)com #
# Bioinformatics Unit (EMBNET node), ¡ URL: http://scorpius.iwarp.com #
# Centre for DNA Fingerprinting and Diagnostics, #
# Hyderabad, India - 500076 #
`************************************************************************/
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Warner | 2000-09-25 01:48:03 | Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef? |
Previous Message | Dominic J. Eidson | 2000-09-25 00:22:29 | Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef? |