From rjessil@yahoo.com Wed Apr 18 00:41:04 2007 Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F0D709FB59E for ; Tue, 17 Apr 2007 21:41:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 36976-08 for ; Tue, 17 Apr 2007 21:40:55 -0300 (ADT) X-Greylist: delayed 00:06:40.019011 by SQLgrey-1.7.4 Received: from web56403.mail.re3.yahoo.com (web56403.mail.re3.yahoo.com [216.252.111.82]) by postgresql.org (Postfix) with SMTP id 3DB599FA6B8 for ; Tue, 17 Apr 2007 21:41:00 -0300 (ADT) Received: (qmail 69702 invoked by uid 60001); 18 Apr 2007 00:34:18 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=IrCjxQwmcxJgMSAPcPxbXYr4FHo20w6tKsQ4mwh87xlaEHi0jTZB+28CcnwIBtNt147B8VoVxQ5rTD2MuAHPl3rsPyG0YePO6dZ1Gny9+YP4cbyp0c69XB7dSx4My5paypgnUEaCkIs9pWovdjJ3DDmy85Znu8GAX+SiFG9LfpM=; X-YMail-OSG: 32iLwXMVM1nE7cIcUsekDsLSNPJMgYZXval_LG0r Received: from [68.0.34.26] by web56403.mail.re3.yahoo.com via HTTP; Tue, 17 Apr 2007 17:34:18 PDT Date: Tue, 17 Apr 2007 17:34:18 -0700 (PDT) From: Jessica Richard Subject: who can tell me the correct syntax to use dblink to talk to a table in another database To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-35390330-1176856458=:69296" Content-Transfer-Encoding: 8bit Message-ID: <690701.69296.qm@web56403.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.131 tagged_above=0 required=5 tests=BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_30_40=0.374, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200704/165 X-Sequence-Number: 25229 --0-35390330-1176856458=:69296 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I installed the dblink module, run dblink.sql to my current database to use the dblink function, but I have not been successful to select a table from a remote database (cross reference). Whoever knows how to use dblink, please show me the syntax to select another table in a remote database. Thanks a lot! Jessica --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos. --0-35390330-1176856458=:69296 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I installed the dblink module, run dblink.sql to my current database to use the dblink function, but I have not been successful to select a table from a remote database (cross reference).

Whoever knows how to use dblink, please show me the syntax to select another table in a remote database. Thanks a lot!

Jessica


Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos. --0-35390330-1176856458=:69296-- From mail@joeconway.com Wed Apr 18 06:26:24 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5DF049FA18C for ; Wed, 18 Apr 2007 03:26:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 22078-08 for ; Wed, 18 Apr 2007 03:26:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from joeconway.com (joeconway.com [68.15.9.201]) by postgresql.org (Postfix) with ESMTP id E72349FA177 for ; Wed, 18 Apr 2007 03:26:19 -0300 (ADT) Received: from [87.139.104.35] (account jconway HELO [192.168.4.101]) by joeconway.com (CommuniGate Pro SMTP 4.1.8) with ESMTP-TLS id 4904251; Tue, 17 Apr 2007 23:26:17 -0700 Message-ID: <4625BA06.1070703@joeconway.com> Date: Tue, 17 Apr 2007 23:26:14 -0700 From: Joe Conway User-Agent: Thunderbird 1.5.0.10 (X11/20070302) MIME-Version: 1.0 To: Jessica Richard CC: pgsql-admin@postgresql.org Subject: Re: who can tell me the correct syntax to use dblink to talk to a table in another database References: <690701.69296.qm@web56403.mail.re3.yahoo.com> In-Reply-To: <690701.69296.qm@web56403.mail.re3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/170 X-Sequence-Number: 25234 Jessica Richard wrote: > I installed the dblink module, run dblink.sql to my current database to > use the dblink function, but I have not been successful to select a > table from a remote database (cross reference). > > Whoever knows how to use dblink, please show me the syntax to select > another table in a remote database. Thanks a lot! See the documentation that comes with dblink, e.g.: http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/doc/query?rev=1.5;content-type=text%2Fplain HTH, Joe