Querying Across Databases..

[Hemapriya]

Hi,

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".

It is unclear whether it is supported or not.

Thanks in Advance

Priya





__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)

[Devrim GUNDUZ]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

Post by Hemapriya
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