PL/pgSQL, short for Procedural Language/PostgreSQL, is a procedural programming language supported by the PostgreSQL object-relational database management system. It closely resembles the PL/SQL language of Oracle. It was implemented by Jan Wieck and first appeared with PostgreSQL 6.4, released on October 30, 1998. The Programming Language Database credits Jan Wieck, dates the language to 1998, records its development within the PostgreSQL Global Development Group, and relates it to PL/SQL, Ada, SQL, SQL/PSM and the Bison parser generator. GitHub and Pygments support syntax highlighting for it, and tens of thousands of public repositories contain code written in it, which shows how widely database-side stored procedures are used.
Facts
First Released Connections
In Field
Invented By
Licensed Under
Source PostgreSQL Global Development Group: PostgreSQL License (About PostgreSQL)
Sources
1. PL/pgSQL (PLDB)
PLDB page header
PL/pgSQL is a programming language created in 1998 by Jan Wieck.
PLDB Wikipedia summary
is a procedural programming language supported by the PostgreSQL ORDBMS
View the SourcePostgreSQL Global Development Group: PostgreSQL License (About PostgreSQL)
PostgreSQL Global Development GroupLicensed Under: PostgreSQL License, About, licenceQuote, Licensed Under: PostgreSQL License, About, licence
PostgreSQL is released under the PostgreSQL License,
Reader Challenges (0)
No disputes yet. Spotted an error or a better source? Open the first one.
Sign in to dispute this or suggest a correction.