{"kind": "psql", "major": "18", "item": {"slug": "cmd-63-72-6f-73-73-74-61-62-76-69-65-77", "name": "\\crosstabview", "name_zh": "", "category": "\u8f93\u51fa\u4e0e\u683c\u5f0f", "summary": "\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002", "aliases": ["\\crosstabview"], "content_hash": "fdbb6dfc0ce38cbaa01343ab51c94ea1d127d7bdb78de7cd2afef4009e3cd57e", "versions": {"10": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 10.23"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=10", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=10", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "label": "10.23", "major": "10", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/10/postgresql-10-A4.pdf", "bytes": 12631706, "pages": 2591, "sha256": "34497ab9efb45c5bdf1bd11b9016b5451354feb462fa029cf74557a5fa5fbbc1", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/10/postgresql-10-US.pdf", "bytes": 12531684, "pages": 2724, "sha256": "429cc7133ddf4f97c560aa466dc9caea4b718721a8321e293357037cf0af4733", "built_at": "2026-09-26"}}, "tree": "10", "index": "index.html", "major": "10", "pages": 1085, "release": "10.23", "source_url": "https://ftp.postgresql.org/pub/source/v10.23/postgresql-10.23.tar.bz2", "svg_assets": 0, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "revision": "f9301feba91e2e2566038a36b8cee0e4402db68989538f88670fddd20b1f78ea", "evidence_kind": "English manual and source declarations", "source_sha256": "94a4b2528372458e5662c18d406629266667c437198160a18cdfd2c4a4d6eee9"}, "sources": [{"url": "https://pg.center/docs/10/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "10.23 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "9e11fe3148cb8c085808f632ed972aa4514332a67758a083a080169101eeb7a4", "language": "en", "original_url": "/docs/10/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span></dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/10/app-psql.html", "method": "same-major semantic node", "sha256": "07e2383663e136e49c565dc43b76b773af4caa89393ce1854d32ec8cc15f2d3c", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[2]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[3]"]}], "language": "zh", "original_text": {"/versions/10/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/10/facts/0/label": "Client", "/versions/10/facts/1/label": "Case-sensitive spelling", "/versions/10/tables/0/title": "Spellings in this manual definition", "/versions/10/related/0/label": "psql command-line options and complete manual", "/versions/10/tables/0/columns/0/label": "Command", "/versions/10/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/10/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "3862db50827e0dd4f072032b649218d308673fda3113bfe8b97e6f7b4c6c08b0"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "11": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 11.22"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=11", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=11", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "label": "11.22", "major": "11", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/11/postgresql-11-A4.pdf", "bytes": 13057499, "pages": 2732, "sha256": "41d75855e610d0d9b8802b87dc5b080bef8d7e91c7cf69401fbf8d3cf801b4b5", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/11/postgresql-11-US.pdf", "bytes": 12961189, "pages": 2883, "sha256": "6a8899ef36935a5b7ed2b436207564a567a4ef1eb1c2200195876b8de4d4fa30", "built_at": "2026-09-26"}}, "tree": "11", "index": "index.html", "major": "11", "pages": 1125, "release": "11.22", "source_url": "https://ftp.postgresql.org/pub/source/v11.22/postgresql-11.22.tar.bz2", "svg_assets": 0, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "revision": "53315ddaf3b3f9e6669fd1edc096bbb2cd4a65ea3e836c89e542b43af9ba3a7f", "evidence_kind": "English manual and source declarations", "source_sha256": "2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0"}, "sources": [{"url": "https://pg.center/docs/11/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "11.22 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "32c4d489e91e59715de2f7c3264fcccab3dd1eca54673dbfeac61304b0c54d4d", "language": "en", "original_url": "/docs/11/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span></dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/11/app-psql.html", "method": "same-major semantic node", "sha256": "01339254dd1dc30d095af846d0b6a7c01f96338187a6fbb8cf45290d5941196b", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[2]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[3]"]}], "language": "zh", "original_text": {"/versions/11/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/11/facts/0/label": "Client", "/versions/11/facts/1/label": "Case-sensitive spelling", "/versions/11/tables/0/title": "Spellings in this manual definition", "/versions/11/related/0/label": "psql command-line options and complete manual", "/versions/11/tables/0/columns/0/label": "Command", "/versions/11/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/11/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "678f958cc3078bd1a51050b75916aca9dac59678cf16e8a6f88acf494f0fd767"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "12": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 12.22"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=12", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=12", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "label": "12.22", "major": "12", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/12/postgresql-12-A4.pdf", "bytes": 13424351, "pages": 2803, "sha256": "7422cf53fd1939e7a3d2925231a88b0330e468afa5393627cac0ff86158a0621", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/12/postgresql-12-US.pdf", "bytes": 13322565, "pages": 2958, "sha256": "51f3b04e72907fc38512685946223452ea65f84419c60c66241dfa3396035e77", "built_at": "2026-09-26"}}, "tree": "12", "index": "index.html", "major": "12", "pages": 1131, "release": "12.22", "source_url": "https://ftp.postgresql.org/pub/source/v12.22/postgresql-12.22.tar.bz2", "svg_assets": 2, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "revision": "7a827e97cbfacd7febff75f34443e2043e40723de5b6d8c9d81a9430b65a37e4", "evidence_kind": "English manual and source declarations", "source_sha256": "8df3c0474782589d3c6f374b5133b1bd14d168086edbc13c6e72e67dd4527a3b"}, "sources": [{"url": "https://pg.center/docs/12/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "12.22 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "a5cec5a456a98610e98d1f1959d96ce57c8413bb392f0f5d6720fc561bb63627", "language": "en", "original_url": "/docs/12/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span></dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/12/app-psql.html", "method": "same-major semantic node", "sha256": "1eb88d17f6ce811d722e5c4ed036f78a7872bf88410c08db794c428e3cfc98ce", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[2]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[3]"]}], "language": "zh", "original_text": {"/versions/12/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/12/facts/0/label": "Client", "/versions/12/facts/1/label": "Case-sensitive spelling", "/versions/12/tables/0/title": "Spellings in this manual definition", "/versions/12/related/0/label": "psql command-line options and complete manual", "/versions/12/tables/0/columns/0/label": "Command", "/versions/12/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/12/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "413a90474c709993d90958c02e60d5d76b35aea2873660cbd7b850bf94201b5a"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "13": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 13.23"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=13", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=13", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "label": "13.23", "major": "13", "channel": "historical", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/13/postgresql-13-A4.pdf", "bytes": 13843239, "pages": 2826, "sha256": "171cc09f90936dbc1cbd503a98ff07ae72ea58ab9771ff051313f1217737799c", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/13/postgresql-13-US.pdf", "bytes": 13739572, "pages": 2984, "sha256": "48d09c6e197d9db4220f41afe83efe848a8661b1b168d3b89419751ecaf6c24d", "built_at": "2026-09-26"}}, "tree": "13", "index": "index.html", "major": "13", "pages": 1139, "release": "13.23", "source_url": "https://ftp.postgresql.org/pub/source/v13.23/postgresql-13.23.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "revision": "614ee3133270254e476c118cdf6f72af78d4e4b8bbd9b28ed9ab1e14e4e9c0f6", "evidence_kind": "English manual and source declarations", "source_sha256": "6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6"}, "sources": [{"url": "https://pg.center/docs/13/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "13.23 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "30347083b7a58da020d968643e2479d2dfb534191d4493d454603ca53db151b0", "language": "en", "original_url": "/docs/13/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span></dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/13/app-psql.html", "method": "same-major semantic node", "sha256": "dd2bf63d81b9a9d3fc69c646197cfdc14a0b1bab1c9f0b98608d66554da4a261", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[2]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[3]"]}], "language": "zh", "original_text": {"/versions/13/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/13/facts/0/label": "Client", "/versions/13/facts/1/label": "Case-sensitive spelling", "/versions/13/tables/0/title": "Spellings in this manual definition", "/versions/13/related/0/label": "psql command-line options and complete manual", "/versions/13/tables/0/columns/0/label": "Command", "/versions/13/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/13/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "c2bbd8622d63ba8f89bb302fca4d10796c49699f37693945c68e560e5ed47999"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "14": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 14.24"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=14", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=14", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "label": "14.24", "major": "14", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/14/postgresql-14-A4.pdf", "bytes": 14354704, "pages": 2944, "sha256": "8bc6b9dd7b246888bb77f0a5e8c39a2eae52e9926569832669c7d1600becb27c", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/14/postgresql-14-US.pdf", "bytes": 14242178, "pages": 3102, "sha256": "b7ecb5a5f62d8b9f73a69e25a7d26ba285373bc53168a553bff7b77955506db4", "built_at": "2026-09-26"}}, "tree": "14", "index": "index.html", "major": "14", "pages": 1158, "release": "14.24", "source_url": "https://ftp.postgresql.org/pub/source/v14.24/postgresql-14.24.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "revision": "588700d46356d8837c77c7c0a4e71e645fe6535983b8f1830aa8f2e4e41c40ae", "evidence_kind": "English manual and source declarations", "source_sha256": "a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897"}, "sources": [{"url": "https://pg.center/docs/14/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "14.24 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "8da20abaee171c53c05658cfb2580dea645070f40bad6b46a845d710ad74c3ae", "language": "en", "original_url": "/docs/14/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span></dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/14/app-psql.html", "method": "same-major semantic node", "sha256": "11c74f85ef9d2c9b3921e0c622d69dd3f1b3ed0c916197a94ddab5540153e310", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[2]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[3]"]}], "language": "zh", "original_text": {"/versions/14/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/14/facts/0/label": "Client", "/versions/14/facts/1/label": "Case-sensitive spelling", "/versions/14/tables/0/title": "Spellings in this manual definition", "/versions/14/related/0/label": "psql command-line options and complete manual", "/versions/14/tables/0/columns/0/label": "Command", "/versions/14/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/14/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "dddc3855daf7cc4dc99c9513ac87390c07a876b94af39fa9efa13c53bd0d6826"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "15": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 15.19"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=15", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=15", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "label": "15.19", "major": "15", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/15/postgresql-15-A4.pdf", "bytes": 14609140, "pages": 2987, "sha256": "66228564a4d16efb47d6a914085716ecfe22ca1566db56bc7c3d82f790646d72", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/15/postgresql-15-US.pdf", "bytes": 14495690, "pages": 3153, "sha256": "645a498c2390d47a6223ec74770631185807a19c484edb0fc5a295d9f460bc02", "built_at": "2026-09-26"}}, "tree": "15", "index": "index.html", "major": "15", "pages": 1168, "release": "15.19", "source_url": "https://ftp.postgresql.org/pub/source/v15.19/postgresql-15.19.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "revision": "6af958c6520151fc7697d56e0616b03fb00522c4568158674d452ae0644ba545", "evidence_kind": "English manual and source declarations", "source_sha256": "e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89"}, "sources": [{"url": "https://pg.center/docs/15/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "15.19 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "cb07228edb4914a53530afca316fd700a250cc062af2d5a74d24add93afbd0c8", "language": "en", "original_url": "/docs/15/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span></dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/15/app-psql.html", "method": "same-major semantic node", "sha256": "8d6ed2e3400192f466dca73fd9423e91b9ede916fe0981b7e0cd42bc091394d2", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[2]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[15]/p[3]"]}], "language": "zh", "original_text": {"/versions/15/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/15/facts/0/label": "Client", "/versions/15/facts/1/label": "Case-sensitive spelling", "/versions/15/tables/0/title": "Spellings in this manual definition", "/versions/15/related/0/label": "psql command-line options and complete manual", "/versions/15/tables/0/columns/0/label": "Command", "/versions/15/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/15/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "ac58b6982a90a73fadde18b02e531e5ef1b0a0013de261fee4d39064c03e4620"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "16": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 16.15"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=16", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=16", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "label": "16.15", "major": "16", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/16/postgresql-16-A4.pdf", "bytes": 15282337, "pages": 3055, "sha256": "4bb6c1f63deedac98736d8c4c7bc0fad0ac24e85b07e21ee10411872f06afd06", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/16/postgresql-16-US.pdf", "bytes": 15164148, "pages": 3220, "sha256": "5b6b6166c89991199e144bb0ae34c17a5f29826251dbf19db1abc0df3a3e771b", "built_at": "2026-09-26"}}, "tree": "16", "index": "index.html", "major": "16", "pages": 1169, "release": "16.15", "source_url": "https://ftp.postgresql.org/pub/source/v16.15/postgresql-16.15.tar.bz2", "svg_assets": 3, "source_mode": "en HTML verified against the pinned official archive", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "revision": "3c21e58b35318021716440e67bb8bafd392b6a2b965a244d90e9e33c99e0bdef", "evidence_kind": "English manual and source declarations", "source_sha256": "c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed"}, "sources": [{"url": "https://pg.center/docs/16/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "16.15 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "add25957a1dfc97db721f2958782be186ab90dc0f0a47c4b720b2b6c26172493", "language": "en", "original_url": "/docs/16/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span> </dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/16/app-psql.html", "method": "same-major semantic node", "sha256": "72833cd861534255277e73a650a16ab07f11c38db9df980213b8335751a3273d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[17]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[17]/p[2]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[17]/p[3]"]}], "language": "zh", "original_text": {"/versions/16/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/16/facts/0/label": "Client", "/versions/16/facts/1/label": "Case-sensitive spelling", "/versions/16/tables/0/title": "Spellings in this manual definition", "/versions/16/related/0/label": "psql command-line options and complete manual", "/versions/16/tables/0/columns/0/label": "Command", "/versions/16/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/16/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "e013d0b93e5540a833eaa61e0e74a535ee0d8bd87574e35726b6ef676bbf5e7a"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "17": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 17.11"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=17", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=17", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/17/postgresql-17-A4.pdf", "bytes": 15521293, "pages": 3099, "sha256": "1991354df0dc89e70ec39328c28988ef8b19c6a93671dab3893650b63e9f4e36", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/17/postgresql-17-US.pdf", "bytes": 15398150, "pages": 3270, "sha256": "07696c8f38abf31babf22d2db337093936e7c472d2af36d050b000c49bbcf52c", "built_at": "2026-09-26"}}, "tree": "17", "index": "index.html", "major": "17", "pages": 1143, "release": "17.11", "source_url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "revision": "58419c9b0dd42cb34c8d53695bb025a7e582edf55ccd4c5bcb1c2c7c71a37487", "evidence_kind": "English manual and source declarations", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "https://pg.center/docs/17/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "17.11 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "04c77661f1c96a64e91a27313542c34aff0c7d2a94e350ed98c6f9f35700629b", "language": "en", "original_url": "/docs/17/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span> </dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/17/app-psql.html", "method": "same-major semantic node", "sha256": "820a5ee48a79666cef06bfe375ea9337e7a347b6d32c921738edd824fe5aa9f8", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[17]/p[0]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[17]/p[2]", "#APP-PSQL/div[7]/div[3]/div[10]/dl[0]/dd[17]/p[3]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/17/facts/0/label": "Client", "/versions/17/facts/1/label": "Case-sensitive spelling", "/versions/17/tables/0/title": "Spellings in this manual definition", "/versions/17/related/0/label": "psql command-line options and complete manual", "/versions/17/tables/0/columns/0/label": "Command", "/versions/17/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/17/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "72c3022fda4d4b8d9904d752f396b8c8f51058ee984826e1afc92636c41af210"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "18": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=18", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span> </dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[2]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[3]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/0/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/18/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "ced37dff54c62d9cd20b77ee605063bfb2b31fb5ce21d20429944f4a8751fe26"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "19": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 19beta4"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=19", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=19", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/19/postgresql-19-A4.pdf", "bytes": 16064841, "pages": 3052, "sha256": "4dd099e4125c591128fc5f3ebd02178dc24781f9e5ae629f96d67c4c8547427b", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/19/postgresql-19-US.pdf", "bytes": 15974616, "pages": 3225, "sha256": "61971fa857f0956d47341a0388fa6af9ae10acf691d4b2fc009007d384b0342b", "built_at": "2026-09-26"}}, "tree": "19", "index": "index.html", "major": "19", "pages": 1155, "release": "19beta4", "source_url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "svg_assets": 5, "source_mode": "en SGML built with pinned official archive", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833", "evidence_kind": "English manual and source declarations", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "https://pg.center/docs/19/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "19beta4 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "312975c12d6e4d62aeebcb5e98e7ca795c6d07ecb743b4bc64403dc42bc2a6e9", "language": "en", "original_url": "/docs/19/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span> </dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/19/app-psql.html", "method": "same-major semantic node", "sha256": "1351be06967585f99a84454a26dff346091ea378daf6c7ed9fa18edee9d1131c", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[2]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[3]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/19/facts/0/label": "Client", "/versions/19/facts/1/label": "Case-sensitive spelling", "/versions/19/tables/0/title": "Spellings in this manual definition", "/versions/19/related/0/label": "psql command-line options and complete manual", "/versions/19/tables/0/columns/0/label": "Command", "/versions/19/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/19/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "01d2a7f000a2f82800153c5de9d09aff678a1575bb7b2cb5a82f83743f9994c6"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "20": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 20devel"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=20", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=20", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/20/postgresql-20-A4.pdf", "bytes": 16030631, "pages": 3052, "sha256": "bd5d82c0ce38fc18f92a0447818a91a193a261776bca1c37564bf9a683e177d0", "built_at": "2026-09-28"}, "US": {"url": "/files/documentation/pdf/20/postgresql-20-US.pdf", "bytes": 15936613, "pages": 3223, "sha256": "d97d9e0db479a02f4234b175f50fcad70c3661619afc8d6df9b9437882e3c299", "built_at": "2026-09-28"}}, "tree": "0", "index": "index.html", "major": "20", "pages": 1156, "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "svg_assets": 6, "source_mode": "en SGML built with pinned official archive", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_snapshot_utc": "26-Sep-2026 20:22"}, "revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918", "evidence_kind": "English manual and source declarations", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "https://pg.center/docs/devel/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "20devel English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "6df5f6fbaff7800ae0e4a08a3116090d890a0cdcc02fddc31c1f220725905f87", "language": "en", "original_url": "/docs/devel/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span> </dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/devel/app-psql.html", "method": "same-major semantic node", "sha256": "1590b6e290ad21fe3ac1c1549628841ae426d1cd07a8f808789207878dbee5ab", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[2]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[3]"]}], "language": "zh", "original_text": {"/summary": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/category": "Output and formatting", "/versions/20/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/20/facts/0/label": "Client", "/versions/20/facts/1/label": "Case-sensitive spelling", "/versions/20/tables/0/title": "Spellings in this manual definition", "/versions/20/related/0/label": "psql command-line options and complete manual", "/versions/20/tables/0/columns/0/label": "Command", "/versions/20/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/20/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "517e14e16bb82c90ddcda15fd77583b63f2c02e73704dc275085f3b9344fa01c"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u5ba2\u6237\u7aef", "value": "psql 18.6"}, {"label": "\u533a\u5206\u5927\u5c0f\u5199\u7684\u5199\u6cd5", "value": "\\crosstabview"}], "tables": [{"key": "spellings", "rows": [{"command": {"url": "/wiki/psql/cmd-63-72-6f-73-73-74-61-62-76-69-65-77/?v=18", "text": "\\crosstabview"}, "modifiers": "\u6b64\u8bed\u6cd5\u7b7e\u540d\u672a\u5217\u51fa"}], "title": "\u672c\u7248\u624b\u518c\u4e2d\u7684\u5199\u6cd5", "columns": [{"key": "command", "label": "\u547d\u4ee4"}, {"key": "modifiers", "label": "\u624b\u518c\u4e2d\u7684\u540e\u7f00\u4fee\u9970\u7b26"}]}], "command": "\\crosstabview", "related": [{"url": "/wiki/tool/psql/?v=18", "label": "psql \u547d\u4ee4\u884c\u9009\u9879\u53ca\u5b8c\u6574\u624b\u518c"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "https://pg.center/docs/18/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "file": "app-psql.html", "label": "18.6 English manual \u00b7 app-psql.html", "anchor": "APP-PSQL-META-COMMANDS-CROSSTABVIEW", "sha256": "fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c", "language": "en", "original_url": "/docs/18/app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW"}], "sections": [], "modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "description": ["\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e \\g \u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531 colV \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531 colH \u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002 colD \u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002 sortcolH \u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002"], "manual_html": "<div><dl class=\"variablelist\"><dt id=\"APP-PSQL-META-COMMANDS-CROSSTABVIEW\"><span class=\"term\"><code class=\"literal\">\\crosstabview [ <em class=\"replaceable\"><code>colV</code></em> [ <em class=\"replaceable\"><code>colH</code></em> [ <em class=\"replaceable\"><code>colD</code></em> [ <em class=\"replaceable\"><code>sortcolH</code></em> ] ] ] ]</code></span> </dt><dd>\n<p lang=\"zh\">\u6267\u884c\u5f53\u524d\u67e5\u8be2\u7f13\u51b2\u533a\uff08\u4e0e<code class=\"literal\">\\g</code>\u7c7b\u4f3c\uff09\uff0c\u5e76\u4ee5\u4ea4\u53c9\u8868\u7f51\u683c\u663e\u793a\u7ed3\u679c\u3002\u67e5\u8be2\u5fc5\u987b\u8fd4\u56de\u81f3\u5c11\u4e09\u5217\u3002\u7531<em class=\"replaceable\"><code>colV</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u7eb5\u5411\u8868\u5934\uff0c\u7531<em class=\"replaceable\"><code>colH</code></em>\u6807\u8bc6\u7684\u8f93\u51fa\u5217\u6210\u4e3a\u6a2a\u5411\u8868\u5934\u3002<em class=\"replaceable\"><code>colD</code></em>\u6807\u8bc6\u8981\u5728\u7f51\u683c\u4e2d\u663e\u793a\u7684\u8f93\u51fa\u5217\u3002<em class=\"replaceable\"><code>sortcolH</code></em>\u6807\u8bc6\u6a2a\u5411\u8868\u5934\u7684\u53ef\u9009\u6392\u5e8f\u5217\u3002</p>\n<p lang=\"zh\">\u6bcf\u4e2a\u5217\u6307\u5b9a\u9879\u53ef\u4ee5\u662f\u4ece 1 \u5f00\u59cb\u7684\u5217\u53f7\uff0c\u4e5f\u53ef\u4ee5\u662f\u5217\u540d\uff1b\u5217\u540d\u9075\u5faa\u5e38\u89c4 SQL \u5927\u5c0f\u5199\u6298\u53e0\u548c\u5f15\u53f7\u89c4\u5219\u3002\u7701\u7565\u65f6\uff0ccolV \u9ed8\u8ba4\u4e3a\u7b2c 1 \u5217\uff0ccolH \u9ed8\u8ba4\u4e3a\u7b2c 2 \u5217\u3002colH \u5fc5\u987b\u4e0e colV \u4e0d\u540c\u3002\u82e5\u4e0d\u6307\u5b9a colD\uff0c\u67e5\u8be2\u7ed3\u679c\u5fc5\u987b\u6070\u6709\u4e09\u5217\uff0c\u65e2\u975e colV \u4e5f\u975e colH \u7684\u90a3\u4e00\u5217\u4f5c\u4e3a colD\u3002</p>\n<p lang=\"zh\">\u7eb5\u5411\u8868\u5934\u663e\u793a\u4e3a\u6700\u5de6\u5217\uff0c\u5305\u542b<em class=\"replaceable\"><code>colV</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5176\u987a\u5e8f\u4e0e\u67e5\u8be2\u7ed3\u679c\u4e2d\u76f8\u540c\uff0c\u4f46\u4f1a\u79fb\u9664\u91cd\u590d\u503c\u3002</p>\n<p lang=\"zh\">\u6a2a\u5411\u8868\u5934\u663e\u793a\u4e3a\u7b2c\u4e00\u884c\uff0c\u5305\u542b<em class=\"replaceable\"><code>colH</code></em>\u5217\u4e2d\u7684\u503c\uff0c\u5e76\u79fb\u9664\u91cd\u590d\u503c\u3002\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u4eec\u6309\u67e5\u8be2\u7ed3\u679c\u4e2d\u7684\u76f8\u540c\u987a\u5e8f\u663e\u793a\u3002\u4f46\u5982\u679c\u7ed9\u51fa\u4e86\u53ef\u9009\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u53c2\u6570\uff0c\u5b83\u6240\u6807\u8bc6\u7684\u5217\u7684\u503c\u5fc5\u987b\u662f\u6574\u6570\uff0c\u800c<em class=\"replaceable\"><code>colH</code></em>\u4e2d\u7684\u503c\u4f1a\u6309\u7167\u5bf9\u5e94\u7684<em class=\"replaceable\"><code>sortcolH</code></em>\u503c\u6392\u5e8f\u540e\u663e\u793a\u5728\u6a2a\u5411\u8868\u5934\u4e2d\u3002</p>\n<p lang=\"zh\">\u4ea4\u53c9\u8868\u4e2d\uff0c\u5bf9\u4e8e colH \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c x \u548c colV \u7684\u6bcf\u4e2a\u4e0d\u540c\u503c y\uff0c\u4ea4\u70b9 (x,y) \u7684\u5355\u5143\u683c\u4fdd\u5b58\u67e5\u8be2\u7ed3\u679c\u4e2d colH=x \u4e14 colV=y \u90a3\u4e00\u884c\u7684 colD \u503c\u3002\u6ca1\u6709\u5339\u914d\u884c\u65f6\u5355\u5143\u683c\u4e3a\u7a7a\uff1b\u5b58\u5728\u591a\u884c\u65f6\u4f1a\u62a5\u9519\u3002</p>\n</dd></dl></div>", "manual_path": "app-psql.html#APP-PSQL-META-COMMANDS-CROSSTABVIEW", "localization": {"status": "complete", "sources": [{"url": "/docs/18/app-psql.html", "method": "same-major semantic node", "sha256": "4ff5633229e0afa7feecc2750a7187d2d45a7eef0ca8febc73e4e5c15ac7fa6d", "language": "zh", "matched_nodes": ["#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[0]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[2]", "#APP-PSQL/div[7]/div[3]/div[11]/dl[0]/dd[21]/p[3]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header.", "/versions/18/facts/0/label": "Client", "/versions/18/facts/1/label": "Case-sensitive spelling", "/versions/18/tables/0/title": "Spellings in this manual definition", "/versions/18/related/0/label": "psql command-line options and complete manual", "/versions/18/tables/0/columns/0/label": "Command", "/versions/18/tables/0/columns/1/label": "Documented suffix modifiers", "/versions/18/tables/0/rows/0/modifiers": "None listed in this signature"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "ced37dff54c62d9cd20b77ee605063bfb2b31fb5ce21d20429944f4a8751fe26"}, "comparison_data": {"modifiers": [], "signature": "\\crosstabview [ colV [ colH [ colD [ sortcolH ] ] ] ]", "spellings": ["\\crosstabview"], "definition": "Executes the current query buffer (like \\g ) and shows the results in a crosstab grid. The query must return at least three columns. The output column identified by colV becomes a vertical header and the output column identified by colH becomes a horizontal header. colD identifies the output column to display within the grid. sortcolH identifies an optional sort column for the horizontal header. Each column specification can be a column number (starting at 1) or a column name. The usual SQL case folding and quoting rules apply to column names. If omitted, colV is taken as column 1 and colH as column 2. colH must differ from colV . If colD is not specified, then there must be exactly three columns in the query result, and the column that is neither colV nor colH is taken to be colD . The vertical header, displayed as the leftmost column, contains the values found in column colV , in the same order as in the query results, but with duplicates removed. The horizontal header, displayed as the first row, contains the values found in column colH , with duplicates removed. By default, these appear in the same order as in the query results. But if the optional sortcolH argument is given, it identifies a column whose values must be integer numbers, and the values from colH will appear in the horizontal header sorted according to the corresponding sortcolH values. Inside the crosstab grid, for each distinct value x of colH and each distinct value y of colV , the cell located at the intersection (x,y) contains the value of the colD column in the query result row for which the value of colH is x and the value of colV is y . If there is no such row, the cell is empty. If there are multiple such rows, an error is reported."}, "comparison_hash": "abf12a81cd555025f4fc46d4903e789a1cd12690887288a72af1c4eec8aefa6b", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}