PL/pgSQL
Sign in to savePL/pgSQL (Procedural Language/PostgreSQL) 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.
Key facts
- Programming language.name
- PL/pgSQL
- Programming language.logo
- 120px
- Programming language.paradigm
- <!-- or:
- Programming language.paradigms
- -->
- Programming language.designer
- Jan Wieck
- Programming language.developer
- PostgreSQL Global Development Group
- Programming language.file format
- <!-- or:
- Programming language.file formats
- -->
- Programming language.influenced by
- PL/SQL, Ada
via Wikipedia infobox
Article
4 sectionsContents
- Comparing with PSM
- Example
- References
- External links
PL/pgSQL (Procedural Language/PostgreSQL) 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.
PL/pgSQL, as a fully featured programming language, allows much more procedural control than SQL, including the ability to use loops and other control structures. SQL statements and triggers can call functions created in the PL/pgSQL language.