Actually I want to load my perl code in postgres function. How would i do that? In C you have the notion of shared objects that you dynamically load in postgres functions. If one has to dynamically load the functionality of some perl code in postgres function, how would that be done? I think i was not clear enough in my last email Thanks Jas On 1/16/07, Adam Rich <adam.r@xxxxxxxxxxxxx> wrote:
You treat it like any other perl code (you don't have to do anything special just because it's in postgres): If it's pure perl code, see "require" http://perldoc.perl.org/functions/require.html If it's a perl module, see "use" http://perldoc.perl.org/functions/use.html If you want to access a C library using perl, see XS: http://perldoc.perl.org/perlxs.html http://perldoc.perl.org/perlxstut.html -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Jasbinder Singh Bali Sent: Tuesday, January 16, 2007 8:07 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: [GENERAL] Dynamic loading of Perl Code in Postgres functions Hi, I have some perl code that I need to load dynamically in my postgres function. How can this be accomplished? I can do it in C using shared objects but don't know how would the same work with perl. Is there anything like shared objects in Perl or something. Thanks, Jas ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
