{
    "mode": "man",
    "parameter": "show",
    "section": "7",
    "url": "https://www.chedong.com/phpMan.php/man/show/7/json",
    "generated": "2026-06-16T09:59:40Z",
    "synopsis": "SHOW name\nSHOW ALL",
    "sections": {
        "NAME": {
            "content": "SHOW - show the value of a run-time parameter\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "SHOW name\nSHOW ALL\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "SHOW will display the current setting of run-time parameters. These variables can be set\nusing the SET statement, by editing the postgresql.conf configuration file, through the\nPGOPTIONS environmental variable (when using libpq or a libpq-based application), or through\ncommand-line flags when starting the postgres server. See Chapter 20 for details.\n",
            "subsections": []
        },
        "PARAMETERS": {
            "content": "name\nThe name of a run-time parameter. Available parameters are documented in Chapter 20 and\non the SET(7) reference page. In addition, there are a few parameters that can be shown\nbut not set:\n\nSERVERVERSION\nShows the server's version number.\n\nSERVERENCODING\nShows the server-side character set encoding. At present, this parameter can be shown\nbut not set, because the encoding is determined at database creation time.\n\nLCCOLLATE\nShows the database's locale setting for collation (text ordering). At present, this\nparameter can be shown but not set, because the setting is determined at database\ncreation time.\n\nLCCTYPE\nShows the database's locale setting for character classification. At present, this\nparameter can be shown but not set, because the setting is determined at database\ncreation time.\n\nISSUPERUSER\nTrue if the current role has superuser privileges.\n\nALL\nShow the values of all configuration parameters, with descriptions.\n",
            "subsections": []
        },
        "NOTES": {
            "content": "The function currentsetting produces equivalent output; see Section 9.27.1. Also, the\npgsettings system view produces the same information.\n",
            "subsections": []
        },
        "EXAMPLES": {
            "content": "Show the current setting of the parameter DateStyle:\n\nSHOW DateStyle;\nDateStyle\n-----------\nISO, MDY\n(1 row)\n\nShow the current setting of the parameter geqo:\n\nSHOW geqo;\ngeqo\n------\non\n(1 row)\n\nShow all settings:\n\nSHOW ALL;\nname         | setting |                description\n-------------------------+---------+-------------------------------------------------\nallowsystemtablemods | off     | Allows modifications of the structure of ...\n.\n.\n.\nxmloption               | content | Sets whether XML data in implicit parsing ...\nzerodamagedpages      | off     | Continues processing past damaged page headers.\n(196 rows)\n",
            "subsections": []
        },
        "COMPATIBILITY": {
            "content": "The SHOW command is a PostgreSQL extension.\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "SET(7), RESET(7)\n\n\n\nPostgreSQL 14.23                                2026                                         SHOW(7)",
            "subsections": []
        }
    },
    "summary": "SHOW - show the value of a run-time parameter",
    "flags": [],
    "examples": [
        "Show the current setting of the parameter DateStyle:",
        "SHOW DateStyle;",
        "DateStyle",
        "-----------",
        "ISO, MDY",
        "(1 row)",
        "Show the current setting of the parameter geqo:",
        "SHOW geqo;",
        "geqo",
        "------",
        "on",
        "(1 row)",
        "Show all settings:",
        "SHOW ALL;",
        "name         | setting |                description",
        "-------------------------+---------+-------------------------------------------------",
        "allowsystemtablemods | off     | Allows modifications of the structure of ...",
        "xmloption               | content | Sets whether XML data in implicit parsing ...",
        "zerodamagedpages      | off     | Continues processing past damaged page headers.",
        "(196 rows)"
    ],
    "see_also": [
        {
            "name": "SET",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/SET/7/json"
        },
        {
            "name": "RESET",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/RESET/7/json"
        }
    ]
}