SYSTEM CATALOGS / SYSTEM CATALOGS
pg_language
Read PG 18 manual ↗The catalog pg_language registers languages in which you can write functions or stored procedures.
- Kind
- System catalogs
- Columns in this snapshot
- 9
- Definition source
- English manual
Columns 9
| Column | Type | Description / reference |
|---|---|---|
oid | oid | Row identifier |
lanname | name | Name of the language |
lanowner | oid | Owner of the language pg_authid.oid |
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 might be replaced by a different mechanism in the future. |
lanpltrusted | bool | True if this is a trusted language, which means that it is believed not to grant access to anything outside the normal SQL execution environment. Only superusers can create functions in untrusted languages. |
lanplcallfoid | 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. Zero for internal languages. pg_proc.oid |
laninline | oid | This references a function that is responsible for executing “inline” anonymous code blocks (DO blocks). Zero if inline blocks are not supported. pg_proc.oid |
lanvalidator | 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. pg_proc.oid |
lanacl | aclitem[] | Access privileges; see Section 5.8 for details |
Column history across versions
Version history 8
- PG 18 → 19changed
- PG 16 → 17changed
- PG 13 → 14changed
- PG 11 → 12changed
- PG 10 → 11changed
- PG 9.6 → 10changed
- PG 9.5 → 9.6changed
- PG 9.2 → 9.3changed
Definition snapshot: english-manuals:6f01363ca34905f154a3ebce7bf… · English manual source