pg_language
pg_language#
The pg_language
system catalog table registers languages in which you can write functions or stored procedures. It is populated by CREATE LANGUAGE
.
Table 1. pg_catalog.pg_language
column |
type |
references |
description |
---|---|---|---|
|
oid |
The object ID |
|
|
name |
Name of the language |
|
|
oid |
pg_authid.oid |
Owner of the language |
|
boolean |
This is false for internal languages (such as SQL) and true for user-defined languages. Currently, |
|
|
boolean |
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 may create functions in untrusted languages. |
|
|
oid |
pg_proc.oid |
For noninternal languages this references the language handler, which is a special function that is responsible for running all functions that are written in the particular language. |
|
oid |
pg_proc.oid |
This references a function that is responsible for running inline anonymous code blocks (see the DO command). Zero if inline blocks are not supported. |
|
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. |
|
aclitem[] |
Access privileges for the language |