X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0561E4758F1 for ; Mon, 14 Apr 2003 11:28:32 -0400 (EDT) Received: from web40502.mail.yahoo.com (web40502.mail.yahoo.com [66.218.78.119]) by postgresql.org (Postfix) with SMTP id C23994758E6 for ; Mon, 14 Apr 2003 11:28:27 -0400 (EDT) Message-ID: <20030414152903.32560.qmail@web40502.mail.yahoo.com> Received: from [80.19.150.242] by web40502.mail.yahoo.com via HTTP; Mon, 14 Apr 2003 17:29:03 CEST Date: Mon, 14 Apr 2003 17:29:03 +0200 (CEST) From: =?iso-8859-1?q?friedrich=20nietzsche?= Subject: connecting to a differnt DB in PL/pgSQL To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-5.8 required=5.0 tests=BAYES_10 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/206 X-Sequence-Number: 12907 Hi all, Is it possible to connect to another database within a PL/PgSQL function? I'm in a function on the "A" database and I need to retrieve some information from a table in a different Database "B" may someone help me? thanks, Danilo. bye. ______________________________________________________________________ Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html