From: | friedrich nietzsche <nietzsche_psql(at)yahoo(dot)it> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: connecting to a differnt DB in PL/pgSQL |
Date: | 2003-04-16 07:54:07 |
Message-ID: | 20030416075407.45063.qmail@web40511.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Avevo gia' risolto il come farlo,
ma grazie lo stesso
Ciao
Danilo
--- Franco Bruno Borghesi
<franco(at)akyasociados(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | pginfo | 2003-04-16 09:16:05 | Re: changing column size and type. |
Previous Message | Rudi Starcevic | 2003-04-16 05:57:47 | Re: changing column size and type. |