PostgreSQL 8.2.6 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Fast Forward | Next |
The PL/Python procedural language allows PostgreSQL functions to be written in the Python language .
To install PL/Python in a particular database, use createlang plpythonu dbname .
Tip: If a language is installed into template1 , all subsequently created databases will have the language installed automatically.
As of PostgreSQL 7.4, PL/Python is only available as an "untrusted" language (meaning it does not offer any way of restricting what users can do in it). It has therefore been renamed to plpythonu . The trusted variant plpython may become available again in future, if a new secure execution mechanism is developed in Python.
Note: Users of source packages must specially enable the build of PL/Python during the installation process. (Refer to the installation instructions for more information.) Users of binary packages might find PL/Python in a separate subpackage.