-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Wed, 23 Jun 2004, Hemapriya wrote:
> Does anyone know how to write queries to tables in
> other database intances in postgres? For examlpe if I
> have two DB instances set up, called "test1" and
> "test2" I may want to run an SQL in "test1" that
> selects data from a table in "test2".
Please see contrib/dblink.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFA2cyRtl86P3SPfQ4RAm6LAJ9QRBIeHGc16hXzvQtlNdOI6ICglQCeJh1Z
lyTDjaKK6hADA5wX74/5ALM=
=IzmX
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
