9.5. Summary
PostgreSQL provides a set of powerful, embedded languages. Because PostgreSQL can easily be extended, it is an easy task to add new languages to the server.
PL/pgSQL is a block-oriented language you can use to write your own extensions to PostgreSQL. In many aspects PL/pgSQL is similar to Oracle's PL/SQL, but there are also some major differences.
Writing triggers is an easy task when using PL/pgSQL. Triggers can be used to perform certain tasks in your database automatically and are supported by almost all sophisticated databases.
Get PHP and PostgreSQL: Advanced Web Programming 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.
