pg_language

A system catalogue table storing information about available languages for functions or stored procedures

pg_language is a system catalogue table storing information about available procedural languages for functions or stored procedures.

psql command

\dL lists available languages.

Definition by PostgreSQL version

pg_language (PostgreSQL 13)

               Table "pg_catalog.pg_language"
    Column     |   Type    | Collation | Nullable | Default
---------------+-----------+-----------+----------+---------
 oid           | oid       |           | not null |
 lanname       | name      |           | not null |
 lanowner      | oid       |           | not null |
 lanispl       | boolean   |           | not null |
 lanpltrusted  | boolean   |           | not null |
 lanplcallfoid | oid       |           | not null |
 laninline     | oid       |           | not null |
 lanvalidator  | oid       |           | not null |
 lanacl        | aclitem[] |           |          |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 12)

               Table "pg_catalog.pg_language"
    Column     |   Type    | Collation | Nullable | Default
---------------+-----------+-----------+----------+---------
 oid           | oid       |           | not null |
 lanname       | name      |           | not null |
 lanowner      | oid       |           | not null |
 lanispl       | boolean   |           | not null |
 lanpltrusted  | boolean   |           | not null |
 lanplcallfoid | oid       |           | not null |
 laninline     | oid       |           | not null |
 lanvalidator  | oid       |           | not null |
 lanacl        | aclitem[] |           |          |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 11)

               Table "pg_catalog.pg_language"
    Column     |   Type    | Collation | Nullable | Default
---------------+-----------+-----------+----------+---------
 lanname       | name      |           | not null |
 lanowner      | oid       |           | not null |
 lanispl       | boolean   |           | not null |
 lanpltrusted  | boolean   |           | not null |
 lanplcallfoid | oid       |           | not null |
 laninline     | oid       |           | not null |
 lanvalidator  | oid       |           | not null |
 lanacl        | aclitem[] |           |          |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 10)

               Table "pg_catalog.pg_language"
    Column     |   Type    | Collation | Nullable | Default
---------------+-----------+-----------+----------+---------
 lanname       | name      |           | not null |
 lanowner      | oid       |           | not null |
 lanispl       | boolean   |           | not null |
 lanpltrusted  | boolean   |           | not null |
 lanplcallfoid | oid       |           | not null |
 laninline     | oid       |           | not null |
 lanvalidator  | oid       |           | not null |
 lanacl        | aclitem[] |           |          |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 9.6)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 laninline     | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 9.5)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 laninline     | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 9.4)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 laninline     | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 9.3)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 laninline     | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 9.2)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 laninline     | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 9.1)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 laninline     | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 9.0)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 laninline     | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 8.4)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 8.3)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanowner      | oid       | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

pg_language (PostgreSQL 8.2)

    Table "pg_catalog.pg_language"
    Column     |   Type    | Modifiers
---------------+-----------+-----------
 lanname       | name      | not null
 lanispl       | boolean   | not null
 lanpltrusted  | boolean   | not null
 lanplcallfoid | oid       | not null
 lanvalidator  | oid       | not null
 lanacl        | aclitem[] |
Indexes:
    "pg_language_name_index" UNIQUE, btree (lanname)
    "pg_language_oid_index" UNIQUE, btree (oid)
    

Documentation: pg_language

Change history

Examples

The default contents of this table, on an installation where no further languages have been installed, will look something like this:

postgres=# SELECT * FROM pg_language;
 lanname  | lanowner | lanispl | lanpltrusted | lanplcallfoid | laninline | lanvalidator | lanacl
----------+----------+---------+--------------+---------------+-----------+--------------+--------
 internal |       10 | f       | f            |             0 |         0 |         2246 |
 c        |       10 | f       | f            |             0 |         0 |         2247 |
 sql      |       10 | f       | t            |             0 |         0 |         2248 |
 plpgsql  |       10 | t       | t            |         12617 |     12618 |        12619 |
(4 rows)

postgres=# \dL
                      List of languages
  Name   |  Owner   | Trusted |         Description          
---------+----------+---------+------------------------------
 plpgsql | postgres | t       | PL/pgSQL procedural language
(1 row)

Categories

Procedural language, System catalogue

See also

CREATE LANGUAGE, pg_pltemplate