On Sun, Aug 27, 2006 at 09:41:39PM -0400, Jasbinder Bali wrote: > 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?
Right. The client machine needs DBI (the database-independent module), DBD::Pg (the PostgreSQL-specific driver), and libpq (the PostgreSQL client library). > Also, how much of a change would it be if i have to migrate my triggers > and functions written for C to Perl That depends on how many triggers you have, how elaborate they are, and how proficient you are at Perl. I tend to use PL/pgSQL for functions that involve a lot of SQL statements; I use PL/Perl or PL/Ruby for things like text manipulation that those languages are good at. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
