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
surface form: PostgreSQL triggers
basedOnLanguage Python
canBeInstalledWithCommand CREATE EXTENSION plpython3u
CREATE EXTENSION plpythonu
category Python database technology
database procedural language
documentationLocation PostgreSQL
surface form: PostgreSQL official documentation
executionLocation inside PostgreSQL server process
hasVariant plpython2u
plpython3u
plpythonu
integratesWith PostgreSQL function manager
PostgreSQL
surface form: PostgreSQL trigger manager

PostgreSQL type system
license PostgreSQL License
maintainedBy PostgreSQL
surface form: PostgreSQL Global Development Group
mapsToPythonTypeSystem PostgreSQL
surface form: PostgreSQL array types

PostgreSQL
surface form: PostgreSQL composite types

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
surface form: Python 2 (legacy)

Python
surface form: Python 3
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