Installing Procedural Languages
In a default installation, PostgreSQL will automatically include the capability for the system to access code written in the PL/pgSQL language. Both PL/Tcl and PL/Perl can also be included by setting their respective compile-time variables (that is, --witht-cl or --with-perl).
To enable a specific PL after the system is in production, however, it is necessary to define it through several steps. There are two methods for accomplishing this, either through the explicit declaration of SQL statements or by using the createlang system utility. The createlang utility helps automate many of the steps needed in the manual creation of a new language and is generally the preferred method. Both methods are covered in the ...
Get PostgreSQL Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
