The pg_language catalog provides information about languages used to write functions and procedures.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
lanname |
name |
The name of the language. |
lanowner |
oid (references pg_authid.oid) |
The OID of the role that owns the language. |
lanispl |
bool |
Specifies whether this is a user-defined procedural language (TRUE) or an internal language such as SQL (FALSE). |
lanpltrusted |
bool |
Specifies whether the language is trusted (TRUE) or untrusted (FALSE). A trusted language is restricted so that it cannot access anything outside the normal SQL execution environment. Functions written in untrusted languages may only be created by superusers. |
lanplcallfoid |
oid (references pg_proc.oid) |
Specifies the OID of the language handler function used to execute functions written in non-internal languages.0 – Internal languages. |
laninline |
oid (references pg_proc.oid) |
The OID of the function that executes inline anonymous code blocks (DO blocks).0 – Inline blocks are not supported. |
lanvalidator |
oid (references pg_proc.oid) |
The OID of the validator function used to check syntax and validate newly created functions.0 – No validator exists. |
lanacl |
aclitem[] |
Access privileges. |