目录

pg_language

一个存储可用语言信息的系统表，用于函数或存储过程

pg_language 是一个 系统目录 表，存储有关函数或存储过程可用的 过程语言 的信息。

pg_language 一直存在于 PostgreSQL 中。

psql 命令

\dL 列出可用的语言。

按 PostgreSQL 版本定义

pg_language (PostgreSQL 19)

               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_oid_index" PRIMARY KEY, btree (oid)
    "pg_language_name_index" UNIQUE CONSTRAINT, btree (lanname)

文档: pg_language

pg_language (PostgreSQL 18)

               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_oid_index" PRIMARY KEY, btree (oid)
    "pg_language_name_index" UNIQUE CONSTRAINT, btree (lanname)

文档: pg_language

pg_language (PostgreSQL 17)

               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_oid_index" PRIMARY KEY, btree (oid)
    "pg_language_name_index" UNIQUE CONSTRAINT, btree (lanname)

文档: pg_language

pg_language (PostgreSQL 16)

               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_oid_index" PRIMARY KEY, btree (oid)
    "pg_language_name_index" UNIQUE CONSTRAINT, btree (lanname)

文档: pg_language

pg_language (PostgreSQL 15)

               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_oid_index" PRIMARY KEY, btree (oid)
    "pg_language_name_index" UNIQUE CONSTRAINT, btree (lanname)

文档: pg_language

pg_language (PostgreSQL 14)

               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_oid_index" PRIMARY KEY, btree (oid)
    "pg_language_name_index" UNIQUE CONSTRAINT, btree (lanname)

文档: pg_language

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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: 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)

文档: pg_language

变更历史

示例

在未安装任何其他语言的安装中，此表的默认内容将大致如下所示

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)

分类

过程语言, 系统目录

另请参阅

CREATE LANGUAGE, pg_pltemplate

反馈

在此处提交关于“pg_language”的任何评论、建议或更正 here。