{"Entry":{"collection":"func","key":"pg-get-loaded-modules","name":"pg_get_loaded_modules","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"17","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"18"}],"content_hash":"eca020676cb26e864e5fd66cc1006e6fee86023a4e6b087eb02cb42271716f87","derived_content_hash":"19ddef78d01266f935241ecfc380228ee5b9b3e2c2849274d212ac5022357eb4","documentation_refresh":{"batch":"20261113","original_source_rev":"wiki-repair-20261023:50554ac5ae609646eceb4e0868eaee742f037587aa60405b09d78b240c0b0752","versions":{"18":"18.7","19":"19rc2"}},"first_version":"18","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.191373+08:00","last_version":"20","name":"pg_get_loaded_modules","name_key":"pg_get_loaded_modules","position":28063,"present_in":["18","19","20"],"repair_provenance":{"original_source_revision":"b7bd9cda","receipt_sha256":"e09fdec781e3fedd2e5ce4393d9322e9882e2d7c1ae58a69036b11845a1cd45f","repair":"wiki-repair-20261023"},"signature":"pg_get_loaded_modules () → setof record ( module_name text, version text, file_name text )","signature_count":1,"slug":"pg-get-loaded-modules","source_rev":"wiki-repair-20261023:50554ac5ae609646eceb4e0868eaee742f037587aa60405b09d78b240c0b0752","summary":"Returns a list of the loadable modules that are loaded into the current server session.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-get-loaded-modules","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-get-loaded-modules","SourceRevision":"wiki-repair-20261023:50554ac5ae609646eceb4e0868eaee742f037587aa60405b09d78b240c0b0752","Facts":{"description":"Returns a list of the loadable modules that are loaded into the current server session. The module_name and version fields are NULL unless the module author supplied values for them using the PG_MODULE_MAGIC_EXT macro. The file_name field gives the file name of the module (shared library).","description_html":"Returns a list of the loadable modules that are loaded into the current server session. The \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e fields are NULL unless the module author supplied values for them using the \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e macro. The \u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e field gives the file name of the module (shared library).","description_zh":"返回当前服务器会话中已加载的可加载模块列表。除非模块作者使用 PG_MODULE_MAGIC_EXT 宏提供了这些值，否则 module_name 和 version 字段为 NULL。file_name 字段给出模块（共享库）的文件名。","description_zh_html":"返回当前服务器会话中已加载的可加载模块列表。除非模块作者使用 \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e 宏提供了这些值，否则 \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e 字段为 NULL。\u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e 字段给出模块（共享库）的文件名。","doc":{"anchor":"FUNCTIONS-INFO-SESSION-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"},"documentation_revision":{"inputs":[{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","version":"18.7"},{"file":"functions-info.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"f9684137c0b9fb17a691c4d905529d114472a507a007c15058f2703962b611d2","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"group":"info","group_label":"系统信息函数和操作符","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Returns a list of the loadable modules that are loaded into the current server session. The module_name and version fields are NULL unless the module author supplied values for them using the PG_MODULE_MAGIC_EXT macro. The file_name field gives the file name of the module (shared library).","description_html":"Returns a list of the loadable modules that are loaded into the current server session. The \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e fields are NULL unless the module author supplied values for them using the \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e macro. The \u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e field gives the file name of the module (shared library).","description_zh":"返回当前服务器会话中已加载的可加载模块列表。除非模块作者使用 PG_MODULE_MAGIC_EXT 宏提供了这些值，否则 module_name 和 version 字段为 NULL。file_name 字段给出模块（共享库）的文件名。","description_zh_html":"返回当前服务器会话中已加载的可加载模块列表。除非模块作者使用 \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e 宏提供了这些值，否则 \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e 字段为 NULL。\u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e 字段给出模块（共享库）的文件名。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_loaded_modules\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_get_loaded_modules () → setof record ( module_name text, version text, file_name text )","zh_from":"same-version-manual"}],"translation_provenance":{"inputs":[{"kind":"current-pgdoc-translation","path":"/Users/vonng/pgsty/pgdoc/zh/18/html/functions-info.html","sha256":"7c33185e79430cfbda432dc4db277115c7ac846afccadfcf904ceb1bf2aa1ba5"}],"kind":"same-version-pgdoc","locale":"zh-Hans","source_revision":"b1b500221dbe5437cfca004d6b04d3f6e422765d","version":"18"},"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-SESSION-TABLE","file":"functions-info.html","sha256":"64499116227a087138bb14f29ff6652b200a176d5df3ce2a089c3d5c226b19b3","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-get-loaded-modules","SourceDatabase":"center","Version":"18","Locale":"en","Title":"pg_get_loaded_modules","Summary":"Returns a list of the loadable modules that are loaded into the current server session. The module_name and version fields are NULL unless the module author supplied values for them using the PG_MODULE_MAGIC_EXT macro. The file_name field gives the file name of the module (shared library).","BodyHTML":"Returns a list of the loadable modules that are loaded into the current server session. The \u003cem\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e and \u003cem\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e fields are NULL unless the module author supplied values for them using the \u003ccode\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e macro. The \u003cem\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e field gives the file name of the module (shared library).","SourceRevision":"wiki-repair-20261023:50554ac5ae609646eceb4e0868eaee742f037587aa60405b09d78b240c0b0752","ContentHash":"f7f44e4bf92849e8d0a9eb263ed8b2f8025e461d5d194379738b0391d97c06a3","Payload":{"description":"Returns a list of the loadable modules that are loaded into the current server session. The module_name and version fields are NULL unless the module author supplied values for them using the PG_MODULE_MAGIC_EXT macro. The file_name field gives the file name of the module (shared library).","description_html":"Returns a list of the loadable modules that are loaded into the current server session. The \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e fields are NULL unless the module author supplied values for them using the \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e macro. The \u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e field gives the file name of the module (shared library).","signatures":[{"description":"Returns a list of the loadable modules that are loaded into the current server session. The module_name and version fields are NULL unless the module author supplied values for them using the PG_MODULE_MAGIC_EXT macro. The file_name field gives the file name of the module (shared library).","description_html":"Returns a list of the loadable modules that are loaded into the current server session. The \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e fields are NULL unless the module author supplied values for them using the \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e macro. The \u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e field gives the file name of the module (shared library).","description_zh":"返回当前服务器会话中已加载的可加载模块列表。除非模块作者使用 PG_MODULE_MAGIC_EXT 宏提供了这些值，否则 module_name 和 version 字段为 NULL。file_name 字段给出模块（共享库）的文件名。","description_zh_html":"返回当前服务器会话中已加载的可加载模块列表。除非模块作者使用 \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e 宏提供了这些值，否则 \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e 字段为 NULL。\u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e 字段给出模块（共享库）的文件名。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_loaded_modules\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_get_loaded_modules () → setof record ( module_name text, version text, file_name text )","zh_from":"same-version-manual"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"4792661734f3d017d0a3c6b107f05e6c735f73111aec2bf00eaa088032e4a1b2","Text":"pg_get_loaded_modules () → setof record ( module_name text, version text, file_name text )","Returns":"setof record","Payload":{"description":"Returns a list of the loadable modules that are loaded into the current server session. The module_name and version fields are NULL unless the module author supplied values for them using the PG_MODULE_MAGIC_EXT macro. The file_name field gives the file name of the module (shared library).","description_html":"Returns a list of the loadable modules that are loaded into the current server session. The \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e and \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e fields are NULL unless the module author supplied values for them using the \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e macro. The \u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e field gives the file name of the module (shared library).","description_zh":"返回当前服务器会话中已加载的可加载模块列表。除非模块作者使用 PG_MODULE_MAGIC_EXT 宏提供了这些值，否则 module_name 和 version 字段为 NULL。file_name 字段给出模块（共享库）的文件名。","description_zh_html":"返回当前服务器会话中已加载的可加载模块列表。除非模块作者使用 \u003ccode class=\"literal\"\u003ePG_MODULE_MAGIC_EXT\u003c/code\u003e 宏提供了这些值，否则 \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e 和 \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e 字段为 NULL。\u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e 字段给出模块（共享库）的文件名。","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_loaded_modules\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003emodule_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eversion\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003efile_name\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_get_loaded_modules () → setof record ( module_name text, version text, file_name text )","zh_from":"same-version-manual"}}],"Spellings":null,"SQLState":null,"Evidence":null}