in reply to Re^2: plperl (postgreSQL perl) get url function
in thread plperl (postgreSQL perl) get url function
see Trusted and Untrusted PL/Perl
I was able to get this to work using plperlu after running CREATE EXTENSION plperlu;
pojCREATE OR REPLACE FUNCTION get(character varying) RETURNS json AS $BODY$ use warnings; use strict; use LWP::Simple; my $content = get($_[0]); $content =~ s/ /%20/g; return $content; $BODY$ LANGUAGE plperlu VOLATILE COST 100;
|
|---|