PL/Tcl
E97111
PL/Tcl is a procedural language extension for PostgreSQL that allows writing database functions and triggers using the Tcl scripting language.
Aliases (1)
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
PostgreSQL procedural language
→
procedural language → server-side programming language → |
| allows |
accessing trigger data from Tcl code
→
calling SQL commands from Tcl code → raising PostgreSQL errors from Tcl code → |
| canBeInstalledWith |
CREATE EXTENSION pltcl
→
CREATE EXTENSION pltclu → |
| category |
database extension
→
scripting language binding → |
| designedFor |
writing PostgreSQL functions in Tcl
→
writing PostgreSQL triggers in Tcl → |
| distributedWith |
PostgreSQL source distribution
→
|
| documentationSection |
PostgreSQL PL/Tcl documentation chapter
→
|
| executionLocation |
server-side
→
|
| executionModel |
invoked per SQL call or trigger event
→
|
| hasSecurityModel |
trusted and untrusted language variants
→
|
| implements |
Tcl interpreter inside PostgreSQL backend
→
|
| integratesWith |
PostgreSQL function manager
→
PostgreSQL trigger manager → PostgreSQL type system → |
| introducedIn |
early PostgreSQL 7.x era (as a contributed language)
→
|
| isTrustedVariant |
pltcl
→
|
| isUntrustedVariant |
pltclu
→
|
| languageHandlerFunction |
pltcl_call_handler
→
|
| license |
same license as PostgreSQL
→
|
| maintainedBy |
PostgreSQL Global Development Group
→
|
| primaryUseCase |
embedding Tcl business logic in PostgreSQL
→
|
| relatedTo |
PL/Perl
→
PL/Python → PL/pgSQL → |
| requires |
Tcl library at build time
→
Tcl library at runtime → |
| runsOn |
PostgreSQL
→
|
| supports |
SPI (Server Programming Interface) access from Tcl
→
TG_* trigger variables → conversion between SQL and Tcl data types → parameter passing between SQL and Tcl → raising NOTICE, WARNING, and ERROR messages → returning composite types → returning sets → trigger NEW and OLD row access → |
| supportsFeature |
stored procedures
→
triggers → user-defined functions → |
| supportsVersion |
Tcl 8.x family (depending on PostgreSQL build)
→
|
| trustedVariantRestricts |
access to file system
→
access to operating system facilities → |
| untrustedVariantAllows |
full Tcl functionality
→
|
| usesLanguage |
Tcl
→
|
Referenced by (2)
| Subject (surface form when different) | Predicate |
|---|---|
|
PL/Tcl
("SPI (Server Programming Interface) access from Tcl")
→
|
supports |
|
PostgreSQL
→
|
supportsLanguage |