Chapter 11. Server-Side Programming
In general, there are two ways to program in PostgreSQL: using one of the internally declared procedural languages (PLs) or using one of the externally available application programming interfaces (APIs). The most basic difference between the two approaches is that procedural languages act as a server-side option, and APIs are used for client-side access.
Server-side programming is code that is actually written, contained, and executed inside the PostgreSQL back-end system. Typically, this code is meant to extend the functionality of the base system and to enable other queries or SQL statements to have access to these customizations.
Client-side programming is used to enable applications that reside outside ...
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.
