From: friedrich nietzsche <nietzsche_psql@yahoo.it>
To: pgsql-sql@postgresql.org
Subject: Re: connecting to a differnt DB in PL/pgSQL
Date: Wed, 16 Apr 2003 09:54:07 +0200 (CEST)
Message-ID: <20030416075407.45063.qmail@web40511.mail.yahoo.com> (raw)
In-Reply-To: <200304141416.08254.franco@akyasociados.com.ar>
Avevo gia' risolto il come farlo,
ma grazie lo stesso
Ciao
Danilo
--- Franco Bruno Borghesi
<franco@akyasociados.com.ar> ha scritto: > you should
install dblink as Tomasz said. To do
> that:
>
> cd ...../postgresql-7.3.2/contrib/dblink
> gmake
> gmake install
>
> then you enter into psql to create the functions:
> \i dblink.psql
>
> then you try (change the params):
>
> SELECT
> *
> FROM
> dblink('host=localhost port=5432 dbname=franco
> user=admin password=1234',
> 'SELECT id, name FROM people')
> AS (id INTEGER, people TEXT);
>
> If you skip the values host, port, ..., the defaults
> will be used.
> If it works in psql, it should work inside a
> function.
>
>
>
>
______________________________________________________________________
Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino
http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: nietzsche_psql@yahoo.it
Subject: Re: connecting to a differnt DB in PL/pgSQL
In-Reply-To: <20030416075407.45063.qmail@web40511.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox