Data Management in Bioinformatics/Add Programming Language to PostgreSQL

Examples of programming language in PostgreSQL
Function example in Python

Function example in pgSQL (equivalent of PL/SQL in postgres).

Checking for language support
SQL query:

OR

createlang utility [params: -d DBNAMES, -U USER, -l is for listing]

Result: Procedural Languages Name   | Trusted? ---+-- plpgsql  | yes plpythonu | no

Adding language support
createlang utility [params: -U USER LANG DBNAME] *requires superuser access to database

Adding C/C++ support may be more involved as it requires compiling the source into ".so" on the server. More details here PostgreSQL: Server Programming