1 - why two databases? Couldn't you have just created two separate SCHEMAS? 2 - if you insist on two separate databases: http://www.postgresql.org/docs/9.2/static/dblink.html
From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Kaleeswaran Velu Sent: Tuesday, October 08, 2013 11:23 AM To: pgsql-sql@postgresql.org Subject: [SQL] Hi Team, I am using PostgreSQL 9.2.3 in Windows platform. I have created two databases in it. Now I want to refer the tables across the databases. Meaning would like to create Database link. Can anyone guide me on how to create a DB link? Thanks and Regards Kaleeswaran Velu
