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