select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Procedural languages

plpython3u

PL/Python3U untrusted procedural language

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packageplpython3u
Version1.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemapg_catalog
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Required by

advcopyPL/Python PostgreSQL extension for copying data to and from S3.
aiHelper functions for AI workflows in PostgreSQL
bedquiltA json object store
cartodbArchived PostgreSQL extension for turning a database into a CartoDB user database.
crankshaftArchived CARTO spatial-analysis functions for clustering, segmentation, and spatial statistics.
fakerWrapper for the Faker Python library
gdpr_anatomizerPrototype GDPR/anatomy anonymization extension implemented with PL/Python and PL/pgSQL helpers.
hstore_plpython3utransform between hstore and plpython3u
htcHorvitz-Thompson continuous-population estimator functions for PostgreSQL.
jevNatural-language row filtering, ranking and classification through TypeSafe
jsonb_plpython3utransform between jsonb and plpython3u
ltree_plpython3utransform between ltree and plpython3u
neo4j-fdwMulticorn-based foreign data wrapper and Cypher functions for Neo4j.
nfiestaPostgreSQL extension implementing nFIESTA forest inventory estimation functionality.
nfiesta_target_dataPostgreSQL extension for manipulation of target data - aggregation of local density contributions at the plot level.
numpy_plpython3utransform between numpy and plpython3u
omni_pythonFirst-class Python support
pg4mlMachine learning framework for PostgreSQL
pg_aggExperimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language.
pg_gitImplements Git-like repositories, commits, branches, merges and remote operations using PostgreSQL-native data and functions.
pg_ocrSelf-contained OCR functions via PL/Python
pg_purrA PostgreSQL extension (via PL/Python) that brings quantum computing capabilities.
pg_sentence_transformerRuns a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table.
pgchy_similarityChemical structure similarity functions for PostgreSQL using Chython and PL/Python.
pgembedGenerate vector embeddings through Ollama, OpenAI, or custom HTTP services
pgorpyOR-tools python accessible from the database
pgpymlRun scikit-learn machine-learning models inside PostgreSQL through PL/Python functions and triggers.
pgrollupcreate rollup tables for fast aggregate queries
pgsmtpSend SMTP email and file attachments from PostgreSQL using untrusted PL/Python functions.
plpy_venvSelect and manage Python virtual environments for PL/Python functions.
plpython3tA SQL-only wrapper that registers PostgreSQL PL/Python 3 handlers as a trusted procedural language named plpython3t.
pspacyPL/Python full-text-search helpers that use spaCy for multilingual lemmatization, tsvector generation and tsquery generation.
s2PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy
stripeExperimental generated SQL/PLPython SDK for calling the Stripe REST API from PostgreSQL.
workalendarPostgreSQL extension for Workalendar

See also

plperlPL/Perl procedural language
plperluPL/PerlU untrusted procedural language
plluaLua as a procedural language
pltclPL/Tcl procedural language
plshPL/sh procedural language
pljavaPL/Java procedural language
plrload R interpreter and execute R script from within a database
plxsltXSLT procedural language for PostgreSQL
plpgsqlPL/pgSQL procedural language
plv8PL/JavaScript (v8) trusted procedural language

Same project

jsonb_plpython3utransform between jsonb and plpython3u
ltree_plpython3utransform between ltree and plpython3u
hstore_plpython3utransform between hstore and plpython3u