Live briefing
Everything about PL/pgSQL
Procedural programming language
PL/pgSQL is a procedural programming language supported by the PostgreSQL ORDBMS. It closely resembles Oracle's PL/SQL language. Implemented by Jan Wieck, PL/pgSQL first appeared with PostgreSQL 6.4, released on October 30, 1998. Version 9 also implements some ISO SQL/PSM features, like overloading of SQL-invoked functions and procedures. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: PL/pgSQLA 5-minute orientation
- Pick up a classic book: Procedural Programming with PostgreSQL PL-PGSQLThe most-reprinted book on the subject
- Read the landmark paper: Dynamic Compilation of User-Defined Functions in PL/pgSQL LanguageCited 0 times
- Go sideways: SQL/PSMA closely related topic
- Go sideways: PL/PerlA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
📚 Books worth reading
- 📕Procedural Programming with PostgreSQL PL-PGSQLShaik Baji, Dinesh Kumar Chemuduru · 2023
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- SQL/PSM SQL/PSM (SQL/Persistent Stored Modules) is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures…
- PL/Perl PL/Perl (Procedural Language/Perl) is a procedural language supported by the PostgreSQL RDBMS. PL/Perl, as an imperative programming language, allows more…
- SQL Structured Query Language (SQL) (pronounced /ˌɛsˌkjuˈɛl/ S-Q-L; or alternatively as /ˈsiːkwəl/ "sequel") is a domain-specific language used to manage data…
- PostgreSQL PostgreSQL (/ˈpoʊstɡrɛskjuˌɛl/ POHST-gres-kew-EL), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing…
- Embedded SQL Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements…
- Stored procedure A stored procedure (also termed prc, proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access…
- Snake case Snake case (sometimes stylized autologically as snake_case) is the naming convention in which each space is replaced with an underscore (_) character,…
- PL/SQL PL/SQL (Procedural Language for SQL) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle…