| PostgreSQL 8.0.26 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 41. System Catalogs | Fast Forward | Next |
The catalog pg_language registers languages in which you can write functions or stored procedures. See CREATE LANGUAGE and Chapter 34 for more information about language handlers.
Table 41-18. pg_language Columns
| Name | Type | References | Description |
|---|---|---|---|
| lanname | name | Name of the language | |
| lanispl | bool | This is false for internal languages (such as SQL) and true for user-defined languages. Currently, pg_dump still uses this to determine which languages need to be dumped, but this may be replaced by a different mechanism sometime. | |
| lanpltrusted | bool | This is a trusted language. If this is an internal language (lanispl is false) then this column is meaningless. | |
| lanplcallfoid | oid | pg_proc.oid | For noninternal languages this references the language handler, which is a special function that is responsible for executing all functions that are written in the particular language. |
| lanvalidator | oid | pg_proc.oid | This references a language validator function that is responsible for checking the syntax and validity of new functions when they are created. Zero if no validator is provided. |
| lanacl | aclitem[] | Access privileges; see GRANT and REVOKE for details. |