Online Documentation for SQL Manager for PostgreSQL

Creating/editing language

Name

The name of the new procedural language. The language name is case insensitive. The name must be unique among the languages in the database.

Trusted

This option specifies that the call handler for the language is safe, i.e. it does not offer an unprivileged user any functionality to bypass access restrictions. If this option is disabled, only users with the PostgreSQL superuser privilege can use this language to create new functions.

Handler function

Select the call handler function for this language from the drop-down list.

Call handler is the name of a previously registered function that will be called to execute the procedural language functions. The call handler for a procedural language must be written in a compiled language such as C with version 1 call convention and registered with PostgreSQL as a function taking no arguments and returning the language_handler type, a placeholder type that is simply used to identify the function as a call handler.

Validator function

Select the validation function for this language from the drop-down list.

Validator function is the name of a previously registered function that will be called when a new function in the language is created, to validate the new function.