PL/Python

E97110

PL/Python is a procedural language extension for PostgreSQL that allows writing database functions and triggers in the Python programming language.

All labels observed (1)

Label Occurrences
PL/Python canonical 2

How this entity was disambiguated

Statements (47)

Predicate Object
instanceOf PostgreSQL extension
procedural language
server-side programming language
allowsWriting PostgreSQL functions
PostgreSQL triggers
linked to: PostgreSQL
basedOnLanguage Python
canBeInstalledWithCommand CREATE EXTENSION plpython3u
CREATE EXTENSION plpythonu
category Python database technology
database procedural language
documentationLocation PostgreSQL official documentation
linked to: PostgreSQL
executionLocation inside PostgreSQL server process
hasVariant plpython2u
plpython3u
plpythonu
integratesWith PostgreSQL function manager
PostgreSQL trigger manager
linked to: PostgreSQL

PostgreSQL type system
license PostgreSQL License
maintainedBy PostgreSQL Global Development Group
linked to: PostgreSQL
mapsToPythonTypeSystem PostgreSQL array types
linked to: PostgreSQL

PostgreSQL composite types
linked to: PostgreSQL

PostgreSQL scalar types
requiresComponent PostgreSQL server compiled with PL/Python support
Python interpreter on server
securityModel untrusted language (plpythonu family)
supportsDatabaseSystem PostgreSQL
supportsDataExchangeFormat binary (for some types)
text
supportsFeature SPI (Server Programming Interface) access
access to PostgreSQL configuration settings
composite-type arguments
composite-type return values
database queries from functions
exception handling
set-returning functions
transaction control via subtransactions
trigger procedures
user-defined functions
supportsLanguageVersion Python 2 (legacy)
linked to: Python

Python 3
linked to: Python
supportsProgrammingParadigm imperative programming
procedural programming
supportsUseCase complex business logic in stored procedures
data transformation inside database
data validation in triggers
trigger-based auditing

How these facts were elicited

Referenced by (2)

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

PostgreSQL supportsLanguage PL/Python
PL/Tcl relatedTo PL/Python