{"Entry":{"collection":"catalog","key":"pg_file_settings","name":"pg_file_settings","aliases":[],"metadata":{"changed_in":[],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.4","order":false,"removed":[],"status":"added","to":"9.5","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.5","listing":[],"order":false,"removed":[],"status":"reworded","to":"9.6","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"9.6","listing":[],"order":false,"removed":[],"status":"reworded","to":"10","types":[],"unlisted":[]}],"column_count":7,"content_hash":"cfb8267fe87338bf5204fe7eb1b9bd323697b963d60852053dc4d40cb17cea49","first_version":"9.5","imported_at":"2026-09-30T00:40:55.532583+08:00","kind":"view","last_version":"20","name":"pg_file_settings","position":29,"present_in":["9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:ee48347897d948ce97aba9a8055e8d115090b1823281bc0da4e4b9e7a5595c65","summary":"The view pg_file_settings provides a summary of the contents of the server's configuration file(s).","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_file_settings","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_file_settings","SourceRevision":"english-manuals:ee48347897d948ce97aba9a8055e8d115090b1823281bc0da4e4b9e7a5595c65","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Full path name of the configuration file","description_zh":"","documented":true,"documented_name":"sourcefile","hidden":false,"name":"sourcefile","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":2,"description":"Line number within the configuration file where the entry appears","description_zh":"","documented":true,"documented_name":"sourceline","hidden":false,"name":"sourceline","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":3,"description":"Order in which the entries are processed (1..n)","description_zh":"","documented":true,"documented_name":"seqno","hidden":false,"name":"seqno","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":4,"description":"Configuration parameter name","description_zh":"","documented":true,"documented_name":"name","hidden":false,"name":"name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":5,"description":"Value to be assigned to the parameter","description_zh":"","documented":true,"documented_name":"setting","hidden":false,"name":"setting","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":6,"description":"True if the value can be applied successfully","description_zh":"","documented":true,"documented_name":"applied","hidden":false,"name":"applied","not_null":false,"references":"","type":"bool","type_modifier":-1,"type_oid":16},{"array_dimensions":0,"attnum":7,"description":"If not null, an error message indicating why this entry could not be applied","description_zh":"","documented":true,"documented_name":"error","hidden":false,"name":"error","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25}],"description":"The view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each “name = value” entry appearing in the files, with annotations indicating whether the value could be applied successfully. Additional row(s) may appear for problems not linked to a “name = value” entry, such as syntax errors in the files.\n\nThis view is helpful for checking whether planned changes in the configuration files will work, or for diagnosing a previous failure. Note that this view reports on the current contents of the files, not on what was last applied by the server. (The pg_settings view is usually sufficient to determine that.)\n\nBy default, the pg_file_settings view can be read only by superusers.","description_zh":"","doc":{"anchor":"id-1.10.5.12.6","file":"view-pg-file-settings.html","lang":"en","sha256":"cfdfe9675c1c977429a34df071b53436e2b99dba22e01c6e2beefa676b2881db","slug":"18"},"kind":"view","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["sourcefile","sourceline","seqno","name","setting","applied","error"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.12.6","file":"view-pg-file-settings.html","lang":"en","sha256":"cfdfe9675c1c977429a34df071b53436e2b99dba22e01c6e2beefa676b2881db","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["sourcefile","sourceline","seqno","name","setting","applied","error"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_file_settings","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_file_settings","Summary":"视图pg_file_settings提供了服务器配置文件的内容摘要。每个“name = value”条目在文件中出现时，此视图中会出现一行，并附有标注，指示该值是否能够成功应用。还可能出现额外的行，用于表示与“name = value”条目无关的问题，例如文件中的语法错误。\n\n这个视图对于检查计划中的配置文件变更是否有效，或者诊断之前的故障很有帮助。请注意，这个视图报告的是文件的当前内容，而不是服务器上最后应用的内容。（通常可以通过pg_settings 视图确定最后一次由服务器应用的内容。）\n\n默认情况下，pg_file_settings视图只能被超级用户读取。","BodyHTML":"\u003cp\u003e视图pg_file_settings提供了服务器配置文件的内容摘要。每个“name = value”条目在文件中出现时，此视图中会出现一行，并附有标注，指示该值是否能够成功应用。还可能出现额外的行，用于表示与“name = value”条目无关的问题，例如文件中的语法错误。\n\n这个视图对于检查计划中的配置文件变更是否有效，或者诊断之前的故障很有帮助。请注意，这个视图报告的是文件的当前内容，而不是服务器上最后应用的内容。（通常可以通过pg_settings 视图确定最后一次由服务器应用的内容。）\n\n默认情况下，pg_file_settings视图只能被超级用户读取。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"30f4e240eb222ce49d8f86b5775c7fd489b92cee2b0c6e04e3a9f0e03d26ab22","Payload":{"columns":[{"description_zh":"配置文件的完整路径名","name":"sourcefile","type":"text","zh_from":"doc"},{"description_zh":"该项在配置文件中出现的行号","name":"sourceline","type":"integer","zh_from":"doc"},{"description_zh":"项被处理的顺序（1..n）","name":"seqno","type":"integer","zh_from":"doc"},{"description_zh":"配置参数名","name":"name","type":"text","zh_from":"doc"},{"description_zh":"将赋给该参数的值","name":"setting","type":"text","zh_from":"doc"},{"description_zh":"如果该值能够成功应用则为真","name":"applied","type":"boolean","zh_from":"doc"},{"description_zh":"如果非空，则为说明该条目为何不能应用的错误消息","name":"error","type":"text","zh_from":"doc"}],"description_zh":"视图pg_file_settings提供了服务器配置文件的内容摘要。每个“name = value”条目在文件中出现时，此视图中会出现一行，并附有标注，指示该值是否能够成功应用。还可能出现额外的行，用于表示与“name = value”条目无关的问题，例如文件中的语法错误。\n\n这个视图对于检查计划中的配置文件变更是否有效，或者诊断之前的故障很有帮助。请注意，这个视图报告的是文件的当前内容，而不是服务器上最后应用的内容。（通常可以通过pg_settings 视图确定最后一次由服务器应用的内容。）\n\n默认情况下，pg_file_settings视图只能被超级用户读取。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}