From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Jasbinder Bali <jsbali(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Shared Objects (Dynamic loading) |
Date: | 2006-08-24 20:28:30 |
Message-ID: | 20060824202830.GA31900@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
On Thu, Aug 24, 2006 at 03:46:00PM -0400, Jasbinder Bali wrote:
> The way we use ECPG for the database related activites while working with
> C, what do i need to look up if i'm using perl.
For information about writing server-side Perl functions see the
PL/Perl documentation (adjust the link if you're using a version
other than 8.1):
http://www.postgresql.org/docs/8.1/interactive/plperl.html
If the function needs to execute SQL statements in the same backend
in which it's running then see the "Database Access from PL/Perl"
section. If it needs to connect to a different database then you
could use the DBI module.
> As alot of people have pointed out that perl is the best language to use
> while dealing with email parsing.
"Best" is a matter of opinion; others might prefer Ruby, Python,
or something else. Perl is good at text handling, it has a large
number of third-party modules (CPAN), and there's a lot of material
written about it so it's a popular choice.
> We have the perl code ready to parse the email.
> Just wondering what would be the best method to deal with database
> (postgresql) calls from the perl code.
See the aforementioned PL/Perl documentation. You could also use
PL/Perl just for parsing and use PL/pgSQL for working with the
database.
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Cohen | 2006-08-24 20:56:12 | Re: XPath and XML support |
Previous Message | marcelo Cortez | 2006-08-24 20:18:12 | lock table problem |
From | Date | Subject | |
---|---|---|---|
Next Message | barbara figueirido | 2006-08-25 01:58:42 | phppgadmin not working under v. 8.1 |
Previous Message | Frank Finner | 2006-08-24 20:10:58 | Re: Shared Objects (Dynamic loading) |