PL/Perl

E427687

PL/Perl is a procedural language extension for PostgreSQL that allows users to write database functions and triggers in the Perl programming language.

All labels observed (1)

Label Occurrences
PL/Perl canonical 1

How this entity was disambiguated

Statements (49)

Predicate Object
instanceOf PostgreSQL extension
procedural language
server-side programming language
allowsWriting database functions
stored procedures
triggers
alternativeTo PL/Python NERFINISHED
PL/Tcl NERFINISHED
PL/pgSQL NERFINISHED
canCall SQL commands via SPI
canReturn composite types
scalar values
sets of rows
category PostgreSQL procedural languages
codeStoredIn PostgreSQL system catalogs NERFINISHED
designedFor server-side Perl in PostgreSQL
documentationSection PostgreSQL PL/Perl documentation
executionEnvironment PostgreSQL server
executionModel interpreted
hasUntrustedVariant plperlu
implementedAs loadable module in PostgreSQL
introducedIn early PostgreSQL 7.x series (as a contrib language)
invokedBy CREATE FUNCTION statements
CREATE TRIGGER statements
isTrustedVariant plperl
languageFamily Perl family NERFINISHED
maintainedBy PostgreSQL Global Development Group NERFINISHED
requires Perl interpreter on server
PostgreSQL superuser to install language
securityModel trusted and untrusted variants
supportsFeature Perl modules (with plperlu) NERFINISHED
SPI (Server Programming Interface) NERFINISHED
complex text processing
error handling
regular expressions
set-returning functions
trigger procedures
supportsLanguage Perl NERFINISHED
supportsVersion multiple Perl versions depending on build
trustedVariantRestrictions no direct access to operating system commands
no direct access to the file system
typicalUseCase complex business logic in triggers
data validation
integration with existing Perl code (via plperlu)
text processing in database functions
untrustedVariantCapabilities can access file system
can execute OS-level operations
can use arbitrary Perl modules
usedWith PostgreSQL NERFINISHED

How these facts were elicited

Referenced by (1)

Full triples — surface form annotated when it differs from this entity's canonical label.

PL/Tcl relatedTo PL/Perl