| From: | Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr> |
|---|---|
| To: | "David Olbersen" <DOlbersen(at)stbernard(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Cross-machine PL/pgSQL? |
| Date: | 2003-03-25 18:49:53 |
| Message-ID: | 200303251849.53187.darko.prenosil@finteh.hr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday 25 March 2003 16:25, David Olbersen wrote:
> Is it possible to access a postgres database running on another machine on
> the network from a pl/pgsql function? I haven't been able to find anything
> in the docs about this and have a feeling it just isn't going to happen :)
>
If You are well familiar with libpq client interface, there is my project on
gborg that encapsulates almost all libpq functions calls and can be used in
pl/psql.
ftp://gborg.postgresql.org/pub/plpq/devel/plpq_src.tar.gz
On the other hand, in /contrib directory of postgres sources there is dblink
tool that might be just what You want.
> --------------------------
> David Olbersen
> iGuard Engineer
> 11415 West Bernardo Court
> San Diego, CA 92127
> 1-858-676-2277 x2152
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Ayers | 2003-03-25 18:55:32 | Re: TEXT datatype and VB6... |
| Previous Message | scott.marlowe | 2003-03-25 17:56:16 | Re: Migrate Mysql to Posgresql |