postgresql-14-plpgsql-check
plpgsql_check extension for PostgreSQL
Description
plpgsql_check is the next generation of plpgsql_lint for PL/pgsql source code. The SQL statements inside PL/pgSQL functions are checked for semantic errors. Features: * check fields of referenced database objects and types inside embedded SQL
* using correct types of function parameters
* unused variables and function argumens, unmodified OUT argumens
* partially detection of dead code (due RETURN command)
* detection of missing RETURN command in function
* try to identify unwanted hidden casts, that can be performance issue like
unused indexes
* possibility to collect relations and functions used by function
* possibility to check EXECUTE stmt against SQL injection vulnerability
Upload more screenshots
Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.
Upload a screenshotHint: upload an image here from your clipboard with Ctrl-V
Homepage
https://github.com/okbob/plpgsql_check
Install this software package
If the package is available for the distribution you are currently using on your computer then install the software by clicking on…
Install postgresql-14-plpgsql-check