Re: Shared Objects (Dynamic loading)

From: "Jasbinder Bali" <jsbali(at)gmail(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Shared Objects (Dynamic loading)
Date: 2006-08-28 01:41:39
Message-ID: a47902760608271841g2dbd63fau6b49e1e24cdbf9d0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

The actual scenario is like my perl code is on one computer and database
server is on the other
computer. The perl code needs to connect to that database server residing on
a diff computer.

I think client machine should also have DBI module in it. right?

Also, how much of a change would it be if i have to migrate my triggers and
functions written for C to Perl

Thanks,
Jas

On 8/27/06, Michael Fuhr <mike(at)fuhr(dot)org> wrote:
>
> On Sun, Aug 27, 2006 at 05:13:25PM -0400, Jasbinder Bali wrote:
> > Can you please give me pointers to how to establish clinet server model
> > using PL/Perl.
> > I mean how do i give the ip address of the database server in my Perl
> script
> > running in another machine.
>
> DBI is a Perl module for connecting to databases; to connect to a
> PostgreSQL database you'll also need DBD::Pg. If you have those
> modules installed then use a command like "man DBI" or "perldoc
> DBI" (or however you read documentation on your system) for more
> information.
>
> Are you creating a PL/Perl function in one database that needs to
> connect to a different database? What exactly are you trying to
> do?
>
> --
> Michael Fuhr
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2006-08-28 02:09:40 Re: [PATCHES] New variable server_version_num
Previous Message Greg Sabino Mullane 2006-08-28 01:02:42 Re: Cutting the Gborg throat

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2006-08-28 05:05:21 Re: Shared Objects (Dynamic loading)
Previous Message Geoffrey 2006-08-28 00:40:53 Re: Shared Objects (Dynamic loading)