Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VU7KY-0005yl-Ti for pgsql-sql@arkaria.postgresql.org; Thu, 10 Oct 2013 03:54:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VU7KY-0000k8-8Y for pgsql-sql@arkaria.postgresql.org; Thu, 10 Oct 2013 03:54:30 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VU7KW-0000k1-Ln for pgsql-sql@postgresql.org; Thu, 10 Oct 2013 03:54:29 +0000 Received: from nm21-vm4.bullet.mail.gq1.yahoo.com ([98.136.217.51]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VU7KS-0000wn-R1 for pgsql-sql@postgresql.org; Thu, 10 Oct 2013 03:54:27 +0000 Received: from [98.137.12.60] by nm21.bullet.mail.gq1.yahoo.com with NNFMP; 10 Oct 2013 03:54:23 -0000 Received: from [98.137.12.209] by tm5.bullet.mail.gq1.yahoo.com with NNFMP; 10 Oct 2013 03:54:23 -0000 Received: from [127.0.0.1] by omp1017.mail.gq1.yahoo.com with NNFMP; 10 Oct 2013 03:54:23 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 116927.55399.bm@omp1017.mail.gq1.yahoo.com Received: (qmail 92588 invoked by uid 60001); 10 Oct 2013 03:54:23 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1381377263; bh=ONjh5IL4kIpuDEh0+3hJREfNjRCe2uOrIZXNINKTRQs=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=PT/gFp4/BvtoSfKQLZd5yosNoxtLnTgzzJ0i7NYujyirn8y5iI6nH/2m4LpvYu/C33uFpbw3wgVI1d6goyuiXxqSBdS3VgPD2f424E/CXUIc6ZgA/m86bVO71IbXJz3ZHxngPzanoo5R5fZKAnHnqqn5BTSySec5atY1z291UNc= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=jNINS0DCmJ/4bbl/krvWK4FQghQGgOYoflOEb5XWzn2LDZLYLGxw9V3rYF+aFiVTid3xpvbxIFvq4uI+0rIGdnjoYtcmf46ie16U9dmxeS+OU+vRJynWjFG36cfuuD/h+AQ4h7Bzz9M3f6eZknUH058VtoLqNzk1lcFN2Hb6n60=; X-YMail-OSG: TGybXGoVM1m2mIQHUEe.yJk2H7AeByHdDyTAqbYI54drvKv Uh_.dN2LsOKKxptpTX2szl2AKuphAsyikG5geufitJgJoeBpEeBCH5uDbV7m I9Jfytw9cqgGNZjeT7WBY02w768tRauZITq.f0L9xTgVpkKMlHVRhuzMe14H UvuG8e8io76D8sekYvoQ9HlbpHB96.UD8md0KoDI3t4Ozs1ldsC.2t8aUK1U 1NijYh_8nVexvcovKKkFULN2JfrjQUBceOPFiREXqFnV_LGGFIBUBjQL2c9W ug2P2X2UNCdxpgEX_Hr3cIjar89CCjDVPXfpKXqbH3t_QxayBMuccA6pwBMj Wt.B.PUt3Ubay_W.68UqPgFLjS1AvSGhY7dc.d9BuvwOzWBCvsU4StsCrdr2 E3CrDSXhkLcWGcrnr0RXKKvSf1BjUkq9urUMIcf_cUARzoqIVGL2og_O64k2 qpwAHRvQZEDoE3QIH6HVzGLQuR9MZEq6VXMxM9QgXm9aD_z46VEQNn3DkSkZ 04RTwlsNpoRR8SCi.Tky42mDLEE6NBC1vO0lvnfAj1G512qQW1OXC5llzfVr I_0eJVFejfe17eI8R0fmu_n0- Received: from [106.217.228.16] by web163902.mail.gq1.yahoo.com via HTTP; Wed, 09 Oct 2013 20:54:22 PDT X-Rocket-MIMEInfo: 002.001, T2ssIGdvdCBpdC4gVGhhbmsgeW91IGV2ZXJ5IG9uZSBmb3IgeW91ciByZXNwb25zZS4KwqAKVGhhbmtzIGFuZCBSZWdhcmRzCkthbGVlc3dhcmFuIFZlbHUKCgoKT24gVHVlc2RheSwgT2N0b2JlciA4LCAyMDEzIDEwOjAwIFBNLCBBbmRyZWFzIEtyZXRzY2htZXIgPGFrcmV0c2NobWVyQHNwYW1mZW5jZS5uZXQ.IHdyb3RlOgogCkthbGVlc3dhcmFuIFZlbHUgPHZfa2FsZWVzQHlhaG9vLmNvbT4gd3JvdGU6CgoKPiBIaSBUZWFtLAo.IEkgYW0gdXNpbmcgUG9zdGdyZVNRTCA5LjIuMyBpbiBXaW5kb3dzIHBsYXQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.160.587 References: <1381249389.79519.YahooMailNeo@web163904.mail.gq1.yahoo.com> <20131008162809.GA7413@tux> Message-ID: <1381377262.90340.YahooMailNeo@web163902.mail.gq1.yahoo.com> Date: Wed, 9 Oct 2013 20:54:22 -0700 (PDT) From: Kaleeswaran Velu Reply-To: Kaleeswaran Velu Subject: Re: To: Andreas Kretschmer , "pgsql-sql@postgresql.org" In-Reply-To: <20131008162809.GA7413@tux> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1584674120-1462379643-1381377262=:90340" X-Pg-Spam-Score: 0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org --1584674120-1462379643-1381377262=:90340 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Ok, got it. Thank you every one for your response.=0A=A0=0AThanks and Regar= ds=0AKaleeswaran Velu=0A=0A=0A=0AOn Tuesday, October 8, 2013 10:00 PM, Andr= eas Kretschmer wrote:=0A =0AKaleeswaran Velu wrote:=0A=0A=0A> Hi Team,=0A> I am using PostgreSQL 9.2.= 3 in Windows platform. I have created two databases=0A> in it. Now I want t= o refer the tables across the databases. Meaning would like=0A> to create D= atabase link. Can anyone guide me on how to create a DB link?=0A=0AYou can = use db_link, see=0Ahttp://www.postgresql.org/docs/9.2/interactive/dblink.ht= ml.=0A=0A9.3 contains more:=0Ahttp://www.postgresql.org/docs/9.3/interactiv= e/postgres-fdw.html=0A=0ABut in general: don't use different databases if y= ou need a=0Across-database-connection. You can use Schemas instead:=0Ahttp:= //www.postgresql.org/docs/9.2/static/ddl-schemas.html=0A=0A=0AAndreas=0A-- = =0AReally, I'm not out to destroy Microsoft. That will just be a completely= =0Aunintentional side effect.=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 = =A0 =A0 =A0 =A0 (Linus Torvalds)=0A"If I was god, I would recompile penguin= with --enable-fly."=A0 (unknown)=0AKaufbach, Saxony, Germany, Europe.=A0 = =A0 =A0 =A0 =A0 =A0 =A0 N 51.05082=B0, E 13.56889=B0=0A=0A=0A-- =0ASent via= pgsql-sql mailing list (pgsql-sql@postgresql.org)=0ATo make changes to you= r subscription:=0Ahttp://www.postgresql.org/mailpref/pgsql-sql --1584674120-1462379643-1381377262=:90340 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Ok, got it. Thank you every one for your response.=
 
Thanks and Regards<= /span>
Kaleeswaran Velu


On Tuesday, October 8, 201= 3 10:00 PM, Andreas Kretschmer <akretschmer@spamfence.net> wrote:
=
Kaleeswaran Velu <v_kalees@yahoo.com> wrote:


> 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 acro= ss the databases. Meaning would like
> to create Datab= ase link. Can anyone guide me on how to create a DB link?


You can use db_link, see
http:/= /www.postgresql.org/docs/9.2/interactive/dblink.html.
9.3 contains more:
http://www.postgresql.org/docs/9.3/interactive/postgres-fdw.ht= ml

But in general: don't use different databases if you need a=
cross-database-connection. You can use Schemas instead:<= br clear=3D"none">http://www.postgresql.org/do= cs/9.2/static/ddl-schemas.html

Andreas
--
Really, I'm= not out to destroy Microsoft. That will just be a completely
unintentional side effect.            &n= bsp;                 (Linus Torvald= s)
"If I was god, I would recompile penguin with --enable= -fly."  (unknown)
Kaufbach, Saxony, Germany, Europe= .              N 51.05082=B0, E 13.56889= =B0


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql



--1584674120-1462379643-1381377262=:90340--