PL/Python
E97110
PL/Python is a procedural language extension for PostgreSQL that allows writing database functions and triggers in the Python programming language.
Statements (47)
| Predicate | Object |
|---|---|
| instanceOf |
PostgreSQL extension
→
procedural language → server-side programming language → |
| allowsWriting |
PostgreSQL functions
→
PostgreSQL triggers → |
| basedOnLanguage |
Python
→
|
| canBeInstalledWithCommand |
CREATE EXTENSION plpython3u
→
CREATE EXTENSION plpythonu → |
| category |
Python database technology
→
database procedural language → |
| documentationLocation |
PostgreSQL official documentation
→
|
| executionLocation |
inside PostgreSQL server process
→
|
| hasVariant |
plpython2u
→
plpython3u → plpythonu → |
| integratesWith |
PostgreSQL function manager
→
PostgreSQL trigger manager → PostgreSQL type system → |
| license |
PostgreSQL License
→
|
| maintainedBy |
PostgreSQL Global Development Group
→
|
| mapsToPythonTypeSystem |
PostgreSQL array types
→
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 2 (legacy)
→
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 → |
Referenced by (2)
| Subject (surface form when different) | Predicate |
|---|---|
|
PL/Tcl
→
|
relatedTo |
|
PostgreSQL
→
|
supportsLanguage |