Languages are the basis for constructing functions in a database. This kind of object generates commands to register a new procedural language in a PostgreSQL database. You can create your own language with its proper syntax through the handler functions but writing these functions is quite an advanced topic and demands the creation of C-styled functions which is not covered by this document.
Attribute | Description |
---|---|
Trusted |
This attribute tells the server that the language does not grant access to data that the user eventually does not have permission to handle. |
Handler Function |
Defines the function that will be called to execute the procedural language's functions. This function must have the following signature: language_handler function() . |
Validator Function |
Defines the function that will be called when a new function in the language is created, to validate that new object. This function must have the signature: void function(oid) . |
Inline Function |
Defines the function that will be called to execute an anonymous code block (a DO command) in this language. This function must have the signature: void function(internal) . |
Language DDL
https://www.postgresql.org/docs/current/static/sql-createlanguage.html
Create custom languages
https://www.postgresql.org/docs/current/static/plhandler.html