Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8E24D4758BD for ; Sat, 16 Nov 2002 15:50:17 -0500 (EST) Received: from joeconway.com (unknown [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id 09F7C4753A1 for ; Sat, 16 Nov 2002 15:50:17 -0500 (EST) Received: from [192.168.5.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 3.5.9) with ESMTP-TLS id 1431010; Sat, 16 Nov 2002 13:34:35 -0800 Message-ID: <3DD6AF2E.4000106@joeconway.com> Date: Sat, 16 Nov 2002 12:48:46 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 To: LR Cc: pgsql-sql@postgresql.org Subject: Re: execute a query in an other db References: <20021112141843.GA27903@wolff.to> <3dd6207d_1@news.bluewin.ch> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/248 X-Sequence-Number: 10390 LR wrote: > Thank you for your answer. > Do you know the name of this package ? > Thx > Lilian > see contrib/dblink. I'd highly recommend using 7.3 (finishing beta, soon to be a release candidate) if you can. It is much better than the one in 7.2 and the syntax has changed some. Joe