PL/Perl

Perl is one of the most common scripting languages in use. It runs on almost all platforms and has wide support in the development community. For these reasons, PL/Perl can be an effective choice when choosing a PostgreSQL PL language.

Like PL/Tcl, the PostgreSQL implementation of PL/Perl only enables specific commands, which are deemed trusted. Essentially, any Perl commands that explicitly deal with the file system, environmental settings, or external modules have been disabled.

It is still possible, however, that errant code created in PL/Perl can negatively impact the base system. Most of these problems are because PL/Perl will still allow the exhaustion of memory and endless loops to be created. Therefore, code created in PL/Perl ...

Get PostgreSQL Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.