Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
PL/pgSQL
open-in-new
<p>PL/pgSQL (Procedural Language/PostgreSQL) is a <a href="/facts/Procedural_programming/7r5xz7kx">procedural</a> <a href="/facts/Programming_language/cWTYbgWa">programming language</a> supported by the <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a> <a href="/facts/ORDBMS/XRQqqj5c">ORDBMS</a>. It closely resembles <a href="/facts/Oracle_Database/FHv5g732">Oracle</a>'s <a href="/facts/PL%2fSQL/LLghPhdc">PL/SQL</a> language. Implemented by Jan Wieck, PL/pgSQL first appeared with PostgreSQL 6.4, released on October 30, 1998. Version 9 also implements some ISO <a href="/facts/SQL%2fPSM/8c26p5km">SQL/PSM</a> features, like overloading of SQL-invoked functions and procedures. </p><p>PL/pgSQL, as a fully featured programming language, allows much more procedural control than <a href="/facts/SQL/UjQLJcYm">SQL</a>, including the ability to use loops and other control structures. SQL statements and <a href="/facts/Database_trigger/yhI7KW6H">triggers</a> can call functions created in the PL/pgSQL language. </p><p>The design of PL/pgSQL aimed to allow PostgreSQL users to perform more complex operations and computations than SQL, while providing ease of use. The language is able to be defined as trusted by the server. </p><p>PL/pgSQL is one of the programming languages included in the standard PostgreSQL distribution, the others being <a href="https://www.postgresql.org/docs/current/static/pltcl.html">PL/Tcl</a>, PL/Perl and PL/Python. In addition, many others are available from third parties, including PL/Java, PL/pgPSM, PL/php, PL/R, PL/Ruby, <a href="https://github.com/petere/plsh">PL/sh</a>, <a href="https://github.com/pllua/pllua">PL/Lua</a>, Postmodern (based on <a href="/facts/Common_Lisp/mq1pRbSF">Common Lisp</a>) and <a href="https://pgxn.org/dist/plv8/doc/plv8.html">PL/v8</a>. PostgreSQL uses <a href="/facts/GNU_bison/tTrt7Vrw">Bison</a> as its parser, making it easy to port many <a href="/facts/Open-source_model/uDWVYJ4V">open-source</a> languages, as well as to <a href="/facts/Code_reuse/DVohfy6U">reuse code</a>. </p>