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