PL/Python

E97110

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

AI illustration

How this image was made

AI-generated illustration of PL/Python

This AI-generated illustration was produced by black-forest-labs/FLUX.2-dev (1024x1024) from a prompt written by openai/gpt-oss-120b from the entity's label + description.

Prompt

Generate an image of PL/Python (PL/Python is a procedural language extension for PostgreSQL that allows writing database functions and triggers in the Python programming language.)

All labels observed (2)

Label Occurrences
PL/Python canonical 6
plpythonu 1

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 (7)

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

PostgreSQL → supportsLanguage → PL/Python ⓘ
PL/Tcl → relatedTo → PL/Python ⓘ
plpython2u → isRelatedTo → plpythonu ⓘ
linked to: PL/Python
PL/Perl → alternativeTo → PL/Python ⓘ
PostgreSQL documentation → covers → PL/Python ⓘ
Greenplum → supports → PL/Python ⓘ