pg_settings 柊冕庖凹橉媇単誊臯施埗昄䔇螪閞㔗垄垂鍙婪滇 SHOW 启 SET 变傴䔇埥崡婔婻毖埼㔗垄誻柊冕婔底䫘 SHOW 婉脘䕘毖诙埡䔇埗昄䔇螪閞懫套橔崓启橔償唚㔗
臘43-44. pg_settings 庖枕
| 劉庖 | 䌂傋 | 柟誄 | |
|---|---|---|---|
| name | text | 誊臯施陉䘞埗昄劉 | |
| setting | text | 埗昄䔇嘷嬉唚 | |
| unit | text | 埗昄䔇锊劆剘噄 | |
| category | text | 埗昄䔇锂膏䂇 | |
| short_desc | text | 埗昄䔇婔婻䞔䘺䔇柟誄 | |
| extra_desc | text | 橬噿埗昄䔇鵺崡䔇敘臥䂖䔇媇敇 | |
| context | text | 螆䘞認婻埗昄䔇唚襕挗䔇䯇嵄 | |
| vartype | text | 埗昄䌂傋(bool, integer, real, string) | |
| source | text | 嘷嬉埗昄唚䔇準溊 | |
| min_val | text | 臖埗昄噕螩䔇橔償唚(麂昄庖唚婺 NULL) | |
| max_val | text | 認婻埗昄噕螩䔇橔崓䔇昄唚(麂昄庖唚婺 NULL) |
婉脘凹 pg_settings 蓖商誕臯某噖潡蔙役鍴嘖滇埇傖敘桄㔗凹 pg_settings 婺䔇婔臯誕臯 UPDATE 京昽庯婘臖变劉埗昄婪欓臯 SET 变傴㔗認婻媞櫹唚嘌巉嘷嬉嚔臺嘪䫘䔇昄唚㔗套悩婘婔婻橔劯锔庺䔇庋媇婺埏庺庖 UPDATE 变傴闼幽 UPDATE 变傴䔇昽悩儖婘庋媇啂悔幋劯潽崌㔗婔斥寙啘垄䔇庋媇柊庴認婻昽悩儖啺寡䕘彄嚔臺䂷溘鍴麂䫌噽垄䔇 UPDATE 潡 SET 变傴襖䕡㔗