{"Entry":{"collection":"func","key":"pg-get-keywords","name":"pg_get_keywords","aliases":[],"metadata":{"changed_in":["14"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"8.3","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"8.4"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"13","group_changed":null,"signatures":{"added":["pg_get_keywords () → setof record ( word text, catcode \"char\", barelabel boolean, catdesc text, baredesc text )"],"removed":["pg_get_keywords () → setof record ( word text, catcode \"char\", catdesc text )"]},"status":"changed","to":"14"}],"content_hash":"b4055d2254280dbfff57a38d6bf3fe31b9daa3a65d617f7d74362ff1501534aa","first_version":"8.4","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.188561+08:00","last_version":"20","name":"pg_get_keywords","name_key":"pg_get_keywords","position":28062,"present_in":["8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_get_keywords () → setof record ( word text, catcode \"char\", barelabel boolean, catdesc text, baredesc text )","signature_count":1,"slug":"pg-get-keywords","source_rev":"b7bd9cda","summary":"Returns a set of records describing the SQL keywords recognized by the server.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-get-keywords","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-get-keywords","SourceRevision":"b7bd9cda","Facts":{"description":"Returns a set of records describing the SQL keywords recognized by the server. The word column contains the keyword. The catcode column contains a category code: U for an unreserved keyword, C for a keyword that can be a column name, T for a keyword that can be a type or function name, or R for a fully reserved keyword. The barelabel column contains true if the keyword can be used as a “bare” column label in SELECT lists, or false if it can only be used after AS. The catdesc column contains a possibly-localized string describing the keyword's category. The baredesc column contains a possibly-localized string describing the keyword's column label status.","description_html":"Returns a set of records describing the SQL keywords recognized by the server. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e column contains the keyword. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e column contains a category code: \u003ccode class=\"literal\"\u003eU\u003c/code\u003e for an unreserved keyword, \u003ccode class=\"literal\"\u003eC\u003c/code\u003e for a keyword that can be a column name, \u003ccode class=\"literal\"\u003eT\u003c/code\u003e for a keyword that can be a type or function name, or \u003ccode class=\"literal\"\u003eR\u003c/code\u003e for a fully reserved keyword. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e column contains \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the keyword can be used as a \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ebare\u003c/span\u003e”\u003c/span\u003e column label in \u003ccode class=\"command\"\u003eSELECT\u003c/code\u003e lists, or \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e if it can only be used after \u003ccode class=\"literal\"\u003eAS\u003c/code\u003e. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e column contains a possibly-localized string describing the keyword's category. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e column contains a possibly-localized string describing the keyword's column label status.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","slug":"18"},"group":"info","group_label":"System Information Functions And Operators","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Returns a set of records describing the SQL keywords recognized by the server. The word column contains the keyword. The catcode column contains a category code: U for an unreserved keyword, C for a keyword that can be a column name, T for a keyword that can be a type or function name, or R for a fully reserved keyword. The barelabel column contains true if the keyword can be used as a “bare” column label in SELECT lists, or false if it can only be used after AS. The catdesc column contains a possibly-localized string describing the keyword's category. The baredesc column contains a possibly-localized string describing the keyword's column label status.","description_html":"Returns a set of records describing the SQL keywords recognized by the server. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e column contains the keyword. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e column contains a category code: \u003ccode class=\"literal\"\u003eU\u003c/code\u003e for an unreserved keyword, \u003ccode class=\"literal\"\u003eC\u003c/code\u003e for a keyword that can be a column name, \u003ccode class=\"literal\"\u003eT\u003c/code\u003e for a keyword that can be a type or function name, or \u003ccode class=\"literal\"\u003eR\u003c/code\u003e for a fully reserved keyword. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e column contains \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the keyword can be used as a \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ebare\u003c/span\u003e”\u003c/span\u003e column label in \u003ccode class=\"command\"\u003eSELECT\u003c/code\u003e lists, or \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e if it can only be used after \u003ccode class=\"literal\"\u003eAS\u003c/code\u003e. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e column contains a possibly-localized string describing the keyword's category. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e column contains a possibly-localized string describing the keyword's column label status.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_keywords\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003e\"char\"\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_get_keywords () → setof record ( word text, catcode \"char\", barelabel boolean, catdesc text, baredesc text )","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-INFO-CATALOG-TABLE","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-get-keywords","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_get_keywords","Summary":"返回描述服务器所识别 SQL 关键字的一组记录。word列包含关键字。catcode列包含类别代码：U表示非保留关键字，C表示可用作列名的关键字，T表示可用作类型名或函数名的关键字，R表示完全保留的关键字。如果关键字可以在SELECT列表中用作“裸”列标签，barelabel列为true；如果只能在AS之后使用，则为false。catdesc列包含描述关键字类别的字符串，该字符串可能已被本地化。baredesc列包含描述关键字列标签状态的字符串，该字符串可能已被本地化。","BodyHTML":"返回描述服务器所识别 SQL 关键字的一组记录。\u003cem\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e列包含关键字。\u003cem\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e列包含类别代码：\u003ccode\u003eU\u003c/code\u003e表示非保留关键字，\u003ccode\u003eC\u003c/code\u003e表示可用作列名的关键字，\u003ccode\u003eT\u003c/code\u003e表示可用作类型名或函数名的关键字，\u003ccode\u003eR\u003c/code\u003e表示完全保留的关键字。如果关键字可以在\u003ccode\u003eSELECT\u003c/code\u003e列表中用作\u003cspan\u003e“\u003cspan\u003e裸\u003c/span\u003e”\u003c/span\u003e列标签，\u003cem\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e列为\u003ccode\u003etrue\u003c/code\u003e；如果只能在\u003ccode\u003eAS\u003c/code\u003e之后使用，则为\u003ccode\u003efalse\u003c/code\u003e。\u003cem\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e列包含描述关键字类别的字符串，该字符串可能已被本地化。\u003cem\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e列包含描述关键字列标签状态的字符串，该字符串可能已被本地化。\u003cpre\u003epg_get_keywords () → setof record ( word text, catcode \u0026#34;char\u0026#34;, barelabel boolean, catdesc text, baredesc text )\u003c/pre\u003e返回描述服务器所识别 SQL 关键字的一组记录。\u003cem\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e列包含关键字。\u003cem\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e列包含类别代码：\u003ccode\u003eU\u003c/code\u003e表示非保留关键字，\u003ccode\u003eC\u003c/code\u003e表示可用作列名的关键字，\u003ccode\u003eT\u003c/code\u003e表示可用作类型名或函数名的关键字，\u003ccode\u003eR\u003c/code\u003e表示完全保留的关键字。如果关键字可以在\u003ccode\u003eSELECT\u003c/code\u003e列表中用作\u003cspan\u003e“\u003cspan\u003e裸\u003c/span\u003e”\u003c/span\u003e列标签，\u003cem\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e列为\u003ccode\u003etrue\u003c/code\u003e；如果只能在\u003ccode\u003eAS\u003c/code\u003e之后使用，则为\u003ccode\u003efalse\u003c/code\u003e。\u003cem\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e列包含描述关键字类别的字符串，该字符串可能已被本地化。\u003cem\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e列包含描述关键字列标签状态的字符串，该字符串可能已被本地化。","SourceRevision":"ca936764","ContentHash":"acf3557c298b5a5b4c0aa44d6e89ee34531837467d418613ea370957ad34c788","Payload":{"description_zh":"返回描述服务器所识别 SQL 关键字的一组记录。word列包含关键字。catcode列包含类别代码：U表示非保留关键字，C表示可用作列名的关键字，T表示可用作类型名或函数名的关键字，R表示完全保留的关键字。如果关键字可以在SELECT列表中用作“裸”列标签，barelabel列为true；如果只能在AS之后使用，则为false。catdesc列包含描述关键字类别的字符串，该字符串可能已被本地化。baredesc列包含描述关键字列标签状态的字符串，该字符串可能已被本地化。","description_zh_html":"返回描述服务器所识别 SQL 关键字的一组记录。\u003cem class=\"parameter\"\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e列包含关键字。\u003cem class=\"parameter\"\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e列包含类别代码：\u003ccode class=\"literal\"\u003eU\u003c/code\u003e表示非保留关键字，\u003ccode class=\"literal\"\u003eC\u003c/code\u003e表示可用作列名的关键字，\u003ccode class=\"literal\"\u003eT\u003c/code\u003e表示可用作类型名或函数名的关键字，\u003ccode class=\"literal\"\u003eR\u003c/code\u003e表示完全保留的关键字。如果关键字可以在\u003ccode class=\"command\"\u003eSELECT\u003c/code\u003e列表中用作\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e裸\u003c/span\u003e”\u003c/span\u003e列标签，\u003cem class=\"parameter\"\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e列为\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e；如果只能在\u003ccode class=\"literal\"\u003eAS\u003c/code\u003e之后使用，则为\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e列包含描述关键字类别的字符串，该字符串可能已被本地化。\u003cem class=\"parameter\"\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e列包含描述关键字列标签状态的字符串，该字符串可能已被本地化。","signatures":[{"description_zh":"返回描述服务器所识别 SQL 关键字的一组记录。word列包含关键字。catcode列包含类别代码：U表示非保留关键字，C表示可用作列名的关键字，T表示可用作类型名或函数名的关键字，R表示完全保留的关键字。如果关键字可以在SELECT列表中用作“裸”列标签，barelabel列为true；如果只能在AS之后使用，则为false。catdesc列包含描述关键字类别的字符串，该字符串可能已被本地化。baredesc列包含描述关键字列标签状态的字符串，该字符串可能已被本地化。","description_zh_html":"返回描述服务器所识别 SQL 关键字的一组记录。\u003cem class=\"parameter\"\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e列包含关键字。\u003cem class=\"parameter\"\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e列包含类别代码：\u003ccode class=\"literal\"\u003eU\u003c/code\u003e表示非保留关键字，\u003ccode class=\"literal\"\u003eC\u003c/code\u003e表示可用作列名的关键字，\u003ccode class=\"literal\"\u003eT\u003c/code\u003e表示可用作类型名或函数名的关键字，\u003ccode class=\"literal\"\u003eR\u003c/code\u003e表示完全保留的关键字。如果关键字可以在\u003ccode class=\"command\"\u003eSELECT\u003c/code\u003e列表中用作\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e裸\u003c/span\u003e”\u003c/span\u003e列标签，\u003cem class=\"parameter\"\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e列为\u003ccode class=\"literal\"\u003etrue\u003c/code\u003e；如果只能在\u003ccode class=\"literal\"\u003eAS\u003c/code\u003e之后使用，则为\u003ccode class=\"literal\"\u003efalse\u003c/code\u003e。\u003cem class=\"parameter\"\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e列包含描述关键字类别的字符串，该字符串可能已被本地化。\u003cem class=\"parameter\"\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e列包含描述关键字列标签状态的字符串，该字符串可能已被本地化。","returns":"setof record","text":"pg_get_keywords () → setof record ( word text, catcode \"char\", barelabel boolean, catdesc text, baredesc text )","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"e847a1a7d02c1a0788b9fb840053003b559a68748ba5ac046752f6fc6b2e0bb4","Text":"pg_get_keywords () → setof record ( word text, catcode \"char\", barelabel boolean, catdesc text, baredesc text )","Returns":"setof record","Payload":{"description":"Returns a set of records describing the SQL keywords recognized by the server. The word column contains the keyword. The catcode column contains a category code: U for an unreserved keyword, C for a keyword that can be a column name, T for a keyword that can be a type or function name, or R for a fully reserved keyword. The barelabel column contains true if the keyword can be used as a “bare” column label in SELECT lists, or false if it can only be used after AS. The catdesc column contains a possibly-localized string describing the keyword's category. The baredesc column contains a possibly-localized string describing the keyword's column label status.","description_html":"Returns a set of records describing the SQL keywords recognized by the server. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e column contains the keyword. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e column contains a category code: \u003ccode class=\"literal\"\u003eU\u003c/code\u003e for an unreserved keyword, \u003ccode class=\"literal\"\u003eC\u003c/code\u003e for a keyword that can be a column name, \u003ccode class=\"literal\"\u003eT\u003c/code\u003e for a keyword that can be a type or function name, or \u003ccode class=\"literal\"\u003eR\u003c/code\u003e for a fully reserved keyword. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e column contains \u003ccode class=\"literal\"\u003etrue\u003c/code\u003e if the keyword can be used as a \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ebare\u003c/span\u003e”\u003c/span\u003e column label in \u003ccode class=\"command\"\u003eSELECT\u003c/code\u003e lists, or \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e if it can only be used after \u003ccode class=\"literal\"\u003eAS\u003c/code\u003e. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e column contains a possibly-localized string describing the keyword's category. The \u003cem class=\"parameter\"\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e column contains a possibly-localized string describing the keyword's column label status.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_keywords\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003eword\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatcode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003e\"char\"\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ebarelabel\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ecatdesc\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ebaredesc\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e )","returns":"setof record","text":"pg_get_keywords () → setof record ( word text, catcode \"char\", barelabel boolean, catdesc text, baredesc text )","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}