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 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
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.