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
This entity first appeared as the object of triple T816967 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
Target entity: PL/Python Context triple: [PostgreSQL, supportsLanguage, PL/Python]
-
A.
PostgreSQL
PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and strong standards compliance.
-
B.
Jython
Jython is an implementation of the Python programming language that runs on the Java platform and allows seamless integration with Java code and libraries.
-
C.
PyPy
PyPy is a high-performance alternative Python interpreter featuring a Just-In-Time (JIT) compiler designed to significantly speed up the execution of Python programs.
-
D.
Python
Python is a monstrous serpent or dragon from Greek mythology, best known for being slain by the god Apollo at Delphi.
-
E.
Python
Python is a high-level, versatile programming language widely used for data analysis, machine learning, web development, and automation.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
Target entity: PL/Python Target entity description: PL/Python is a procedural language extension for PostgreSQL that allows writing database functions and triggers in the Python programming language.
-
A.
PostgreSQL
PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and strong standards compliance.
-
B.
Jython
Jython is an implementation of the Python programming language that runs on the Java platform and allows seamless integration with Java code and libraries.
-
C.
PyPy
PyPy is a high-performance alternative Python interpreter featuring a Just-In-Time (JIT) compiler designed to significantly speed up the execution of Python programs.
-
D.
Python
Python is a monstrous serpent or dragon from Greek mythology, best known for being slain by the god Apollo at Delphi.
-
E.
Python
Python is a high-level, versatile programming language widely used for data analysis, machine learning, web development, and automation.
- F. None of above. chosen
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
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Subject: PL/Python Description of subject: PL/Python is a procedural language extension for PostgreSQL that allows writing database functions and triggers in the Python programming language.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.