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@fuhr.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