October 2001
Beginner to intermediate
400 pages
7h 45m
English
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 ...
Read now
Unlock full access