目录

pg_config (视图)

描述 PostgreSQL 编译时配置参数的系统视图

pg_config 是一个 系统目录 视图，它描述了当前 PostgreSQL 实例的编译时配置参数。

pg_config 添加于 PostgreSQL 9.6。

用法

pg_config 以可通过 SQL 查询的形式提供 pg_config 实用程序的输出。

请注意，pg_config 的未过滤输出似乎是有序的，与 pg_config 实用程序的输出相同。

按 PostgreSQL 版本定义

pg_config (PostgreSQL 13)

           View "pg_catalog.pg_config"
 Column  | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
 name    | text |           |          |
 setting | text |           |          |

文档: pg_config

pg_config (PostgreSQL 12)

           View "pg_catalog.pg_config"
 Column  | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
 name    | text |           |          |
 setting | text |           |          |

文档: pg_config

pg_config (PostgreSQL 11)

           View "pg_catalog.pg_config"
 Column  | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
 name    | text |           |          |
 setting | text |           |          |

文档: pg_config

pg_config (PostgreSQL 10)

           View "pg_catalog.pg_config"
 Column  | Type | Collation | Nullable | Default
---------+------+-----------+----------+---------
 name    | text |           |          |
 setting | text |           |          |

文档: pg_config

pg_config (PostgreSQL 9.6)

View "pg_catalog.pg_config"
 Column  | Type | Modifiers
---------+------+-----------
 name    | text |
 setting | text |

文档: pg_config

变更历史

示例

postgres=# SELECT * FROM pg_config;
       name        |                                                                                              setting
-------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 BINDIR            | /home/pguser/postgres/builds/96/bin
 DOCDIR            | /home/pguser/postgres/builds/96/share/doc
 HTMLDIR           | /home/pguser/postgres/builds/96/share/doc
 INCLUDEDIR        | /home/pguser/postgres/builds/96/include
 PKGINCLUDEDIR     | /home/pguser/postgres/builds/96/include
 INCLUDEDIR-SERVER | /home/pguser/postgres/builds/96/include/server
 LIBDIR            | /home/pguser/postgres/builds/96/lib
 PKGLIBDIR         | /home/pguser/postgres/builds/96/lib
 LOCALEDIR         | /home/pguser/postgres/builds/96/share/locale
 MANDIR            | /home/pguser/postgres/builds/96/share/man
 SHAREDIR          | /home/pguser/postgres/builds/96/share
 SYSCONFDIR        | /home/pguser/postgres/builds/96/etc
 PGXS              | /home/pguser/postgres/builds/96/lib/pgxs/src/makefiles/pgxs.mk
 CONFIGURE         | '--prefix=/home/pguser/postgres/builds/96' 'LDFLAGS=-L/opt/local/lib'
 CC                | gcc
 CPPFLAGS          | -DFRONTEND
 CFLAGS            | -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2
 CFLAGS_SL         |
 LDFLAGS           | -L../../src/common -L/opt/local/lib -Wl,-dead_strip_dylibs
 LDFLAGS_EX        |
 LDFLAGS_SL        |
 LIBS              | -lpgcommon -lpgport -lz -lreadline -lm
 VERSION           | PostgreSQL 9.6.6
(23 rows)

分类

PostgreSQL 内部机制, 系统目录

另见

pg_config

反馈

请在此处提交关于“pg_config (视图)”的任何评论、建议或更正 此处。