{"Entry":{"collection":"psql","key":"cmd-64-66","name":"\\df","aliases":["\\df","\\df+","\\dfS","\\dfS+","\\dfSx","\\dfSx+","\\dfa","\\dfa+","\\dfaS","\\dfaS+","\\dfaSx","\\dfaSx+","\\dfan","\\dfan+","\\dfanS","\\dfanS+","\\dfanSx","\\dfanSx+","\\dfanp","\\dfanp+","\\dfanpS","\\dfanpS+","\\dfanpSx","\\dfanpSx+","\\dfanpt","\\dfanpt+","\\dfanptS","\\dfanptS+","\\dfanptSx","\\dfanptSx+","\\dfanptw","\\dfanptw+","\\dfanptwS","\\dfanptwS+","\\dfanptwSx","\\dfanptwSx+","\\dfanptwx","\\dfanptwx+","\\dfanptx","\\dfanptx+","\\dfanpw","\\dfanpw+","\\dfanpwS","\\dfanpwS+","\\dfanpwSx","\\dfanpwSx+","\\dfanpwx","\\dfanpwx+","\\dfanpx","\\dfanpx+","\\dfant","\\dfant+","\\dfantS","\\dfantS+","\\dfantSx","\\dfantSx+","\\dfantw","\\dfantw+","\\dfantwS","\\dfantwS+","\\dfantwSx","\\dfantwSx+","\\dfantwx","\\dfantwx+","\\dfantx","\\dfantx+","\\dfanw","\\dfanw+","\\dfanwS","\\dfanwS+","\\dfanwSx","\\dfanwSx+","\\dfanwx","\\dfanwx+","\\dfanx","\\dfanx+","\\dfap","\\dfap+","\\dfapS","\\dfapS+","\\dfapSx","\\dfapSx+","\\dfapt","\\dfapt+","\\dfaptS","\\dfaptS+","\\dfaptSx","\\dfaptSx+","\\dfaptw","\\dfaptw+","\\dfaptwS","\\dfaptwS+","\\dfaptwSx","\\dfaptwSx+","\\dfaptwx","\\dfaptwx+","\\dfaptx","\\dfaptx+","\\dfapw","\\dfapw+","\\dfapwS","\\dfapwS+","\\dfapwSx","\\dfapwSx+","\\dfapwx","\\dfapwx+","\\dfapx","\\dfapx+","\\dfat","\\dfat+","\\dfatS","\\dfatS+","\\dfatSx","\\dfatSx+","\\dfatw","\\dfatw+","\\dfatwS","\\dfatwS+","\\dfatwSx","\\dfatwSx+","\\dfatwx","\\dfatwx+","\\dfatx","\\dfatx+","\\dfaw","\\dfaw+","\\dfawS","\\dfawS+","\\dfawSx","\\dfawSx+","\\dfawx","\\dfawx+","\\dfax","\\dfax+","\\dfn","\\dfn+","\\dfnS","\\dfnS+","\\dfnSx","\\dfnSx+","\\dfnp","\\dfnp+","\\dfnpS","\\dfnpS+","\\dfnpSx","\\dfnpSx+","\\dfnpt","\\dfnpt+","\\dfnptS","\\dfnptS+","\\dfnptSx","\\dfnptSx+","\\dfnptw","\\dfnptw+","\\dfnptwS","\\dfnptwS+","\\dfnptwSx","\\dfnptwSx+","\\dfnptwx","\\dfnptwx+","\\dfnptx","\\dfnptx+","\\dfnpw","\\dfnpw+","\\dfnpwS","\\dfnpwS+","\\dfnpwSx","\\dfnpwSx+","\\dfnpwx","\\dfnpwx+","\\dfnpx","\\dfnpx+","\\dfnt","\\dfnt+","\\dfntS","\\dfntS+","\\dfntSx","\\dfntSx+","\\dfntw","\\dfntw+","\\dfntwS","\\dfntwS+","\\dfntwSx","\\dfntwSx+","\\dfntwx","\\dfntwx+","\\dfntx","\\dfntx+","\\dfnw","\\dfnw+","\\dfnwS","\\dfnwS+","\\dfnwSx","\\dfnwSx+","\\dfnwx","\\dfnwx+","\\dfnx","\\dfnx+","\\dfp","\\dfp+","\\dfpS","\\dfpS+","\\dfpSx","\\dfpSx+","\\dfpt","\\dfpt+","\\dfptS","\\dfptS+","\\dfptSx","\\dfptSx+","\\dfptw","\\dfptw+","\\dfptwS","\\dfptwS+","\\dfptwSx","\\dfptwSx+","\\dfptwx","\\dfptwx+","\\dfptx","\\dfptx+","\\dfpw","\\dfpw+","\\dfpwS","\\dfpwS+","\\dfpwSx","\\dfpwSx+","\\dfpwx","\\dfpwx+","\\dfpx","\\dfpx+","\\dft","\\dft+","\\dftS","\\dftS+","\\dftSx","\\dftSx+","\\dftw","\\dftw+","\\dftwS","\\dftwS+","\\dftwSx","\\dftwSx+","\\dftwx","\\dftwx+","\\dftx","\\dftx+","\\dfw","\\dfw+","\\dfwS","\\dfwS+","\\dfwSx","\\dfwSx+","\\dfwx","\\dfwx+","\\dfx","\\dfx+"],"metadata":{"aliases":["\\df","\\df+","\\dfS","\\dfS+","\\dfSx","\\dfSx+","\\dfa","\\dfa+","\\dfaS","\\dfaS+","\\dfaSx","\\dfaSx+","\\dfan","\\dfan+","\\dfanS","\\dfanS+","\\dfanSx","\\dfanSx+","\\dfanp","\\dfanp+","\\dfanpS","\\dfanpS+","\\dfanpSx","\\dfanpSx+","\\dfanpt","\\dfanpt+","\\dfanptS","\\dfanptS+","\\dfanptSx","\\dfanptSx+","\\dfanptw","\\dfanptw+","\\dfanptwS","\\dfanptwS+","\\dfanptwSx","\\dfanptwSx+","\\dfanptwx","\\dfanptwx+","\\dfanptx","\\dfanptx+","\\dfanpw","\\dfanpw+","\\dfanpwS","\\dfanpwS+","\\dfanpwSx","\\dfanpwSx+","\\dfanpwx","\\dfanpwx+","\\dfanpx","\\dfanpx+","\\dfant","\\dfant+","\\dfantS","\\dfantS+","\\dfantSx","\\dfantSx+","\\dfantw","\\dfantw+","\\dfantwS","\\dfantwS+","\\dfantwSx","\\dfantwSx+","\\dfantwx","\\dfantwx+","\\dfantx","\\dfantx+","\\dfanw","\\dfanw+","\\dfanwS","\\dfanwS+","\\dfanwSx","\\dfanwSx+","\\dfanwx","\\dfanwx+","\\dfanx","\\dfanx+","\\dfap","\\dfap+","\\dfapS","\\dfapS+","\\dfapSx","\\dfapSx+","\\dfapt","\\dfapt+","\\dfaptS","\\dfaptS+","\\dfaptSx","\\dfaptSx+","\\dfaptw","\\dfaptw+","\\dfaptwS","\\dfaptwS+","\\dfaptwSx","\\dfaptwSx+","\\dfaptwx","\\dfaptwx+","\\dfaptx","\\dfaptx+","\\dfapw","\\dfapw+","\\dfapwS","\\dfapwS+","\\dfapwSx","\\dfapwSx+","\\dfapwx","\\dfapwx+","\\dfapx","\\dfapx+","\\dfat","\\dfat+","\\dfatS","\\dfatS+","\\dfatSx","\\dfatSx+","\\dfatw","\\dfatw+","\\dfatwS","\\dfatwS+","\\dfatwSx","\\dfatwSx+","\\dfatwx","\\dfatwx+","\\dfatx","\\dfatx+","\\dfaw","\\dfaw+","\\dfawS","\\dfawS+","\\dfawSx","\\dfawSx+","\\dfawx","\\dfawx+","\\dfax","\\dfax+","\\dfn","\\dfn+","\\dfnS","\\dfnS+","\\dfnSx","\\dfnSx+","\\dfnp","\\dfnp+","\\dfnpS","\\dfnpS+","\\dfnpSx","\\dfnpSx+","\\dfnpt","\\dfnpt+","\\dfnptS","\\dfnptS+","\\dfnptSx","\\dfnptSx+","\\dfnptw","\\dfnptw+","\\dfnptwS","\\dfnptwS+","\\dfnptwSx","\\dfnptwSx+","\\dfnptwx","\\dfnptwx+","\\dfnptx","\\dfnptx+","\\dfnpw","\\dfnpw+","\\dfnpwS","\\dfnpwS+","\\dfnpwSx","\\dfnpwSx+","\\dfnpwx","\\dfnpwx+","\\dfnpx","\\dfnpx+","\\dfnt","\\dfnt+","\\dfntS","\\dfntS+","\\dfntSx","\\dfntSx+","\\dfntw","\\dfntw+","\\dfntwS","\\dfntwS+","\\dfntwSx","\\dfntwSx+","\\dfntwx","\\dfntwx+","\\dfntx","\\dfntx+","\\dfnw","\\dfnw+","\\dfnwS","\\dfnwS+","\\dfnwSx","\\dfnwSx+","\\dfnwx","\\dfnwx+","\\dfnx","\\dfnx+","\\dfp","\\dfp+","\\dfpS","\\dfpS+","\\dfpSx","\\dfpSx+","\\dfpt","\\dfpt+","\\dfptS","\\dfptS+","\\dfptSx","\\dfptSx+","\\dfptw","\\dfptw+","\\dfptwS","\\dfptwS+","\\dfptwSx","\\dfptwSx+","\\dfptwx","\\dfptwx+","\\dfptx","\\dfptx+","\\dfpw","\\dfpw+","\\dfpwS","\\dfpwS+","\\dfpwSx","\\dfpwSx+","\\dfpwx","\\dfpwx+","\\dfpx","\\dfpx+","\\dft","\\dft+","\\dftS","\\dftS+","\\dftSx","\\dftSx+","\\dftw","\\dftw+","\\dftwS","\\dftwS+","\\dftwSx","\\dftwSx+","\\dftwx","\\dftwx+","\\dftx","\\dftx+","\\dfw","\\dfw+","\\dfwS","\\dfwS+","\\dfwSx","\\dfwSx+","\\dfwx","\\dfwx+","\\dfx","\\dfx+"],"category":"Describe database objects","content_hash":"3d60136ba9d7abaf77ac5659bf9b6540a522ba443e1cd4cecb3b57eaec05e2d1","derived_content_hash":"3c46f84c99b38621f7ead907e7bc9538cb1129afb7a3778e9772cded965bd080","documentation_refresh":{"batch":"20261113","original_source_rev":"","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"imported_at":"2026-09-30T00:40:44.891042+08:00","name":"\\df","name_zh":"","slug":"cmd-64-66","summary":"Lists functions, together with their result data types, argument data types, and function types, which are classified as “ agg ” (aggregate), “ normal ” , “ procedure ” , “ trigger ” , or “ window ” . To display only functions of specific type(s), add the corresponding letters a , n , p , t , or w to the command. If pattern is specified, only functions whose names match the pattern are shown. Any additional arguments are type-name patterns, which are matched to the type names of the first, second, and so on arguments of the function. (Matching functions can have more arguments than what you specify. To prevent that, write a dash - as the last arg_pattern .) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each function is shown, including volatility, parallel safety, owner, security classification, whether it is leakproof, access privileges, language, internal name (for C and internal functions only), and description. Source code for a specific function can be seen using \\sf ."}},"Definition":{"Collection":"psql","Key":"cmd-64-66","SourceDatabase":"center","Version":"18","SourceTable":"psql_command","SourceKey":"cmd-64-66","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","Facts":{"command":"\\df","comparison_data":{"definition":"Lists functions, together with their result data types, argument data types, and function types, which are classified as “ agg ” (aggregate), “ normal ” , “ procedure ” , “ trigger ” , or “ window ” . To display only functions of specific type(s), add the corresponding letters a , n , p , t , or w to the command. If pattern is specified, only functions whose names match the pattern are shown. Any additional arguments are type-name patterns, which are matched to the type names of the first, second, and so on arguments of the function. (Matching functions can have more arguments than what you specify. To prevent that, write a dash - as the last arg_pattern .) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each function is shown, including volatility, parallel safety, owner, security classification, whether it is leakproof, access privileges, language, internal name (for C and internal functions only), and description. Source code for a specific function can be seen using \\sf .","modifiers":[{"command":"\\df","modifiers":"anptwSx+"}],"signature":"\\df[anptwSx+] [ pattern [ arg_pattern ... ] ]","spellings":["\\df"]},"comparison_hash":"463540b1f5bb6a87e6284c97df28e516b177096935047a9a6bfb5009264a5927","description":["Lists functions, together with their result data types, argument data types, and function types, which are classified as “ agg ” (aggregate), “ normal ” , “ procedure ” , “ trigger ” , or “ window ” . To display only functions of specific type(s), add the corresponding letters a , n , p , t , or w to the command. If pattern is specified, only functions whose names match the pattern are shown. Any additional arguments are type-name patterns, which are matched to the type names of the first, second, and so on arguments of the function. (Matching functions can have more arguments than what you specify. To prevent that, write a dash - as the last arg_pattern .) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each function is shown, including volatility, parallel safety, owner, security classification, whether it is leakproof, access privileges, language, internal name (for C and internal functions only), and description. Source code for a specific function can be seen using \\sf ."],"description_zh":"列出函数，以及它们的结果数据类型、参数数据类型和函数类型，函数类型分为 “ agg ” （聚合）、 “ normal ” 、 “ procedure ” 、 “ trigger ” 或 “ window ” 。要只显示特定类型的函数，请在命令后添加相应的字母 a 、 n 、 p 、 t 或 w 。如果指定了 pattern ，则只显示名称与模式匹配的函数。任何附加参数都是类型名模式，分别与函数第一、第二等参数的类型名匹配。（匹配到的函数可以比你指定的参数更多；若要防止这种情况，可将连字符 - 写成最后一个 arg_pattern 。）默认情况下，只显示用户创建的对象；提供模式或 S 修饰符可包括系统对象。如果在命令名后追加 x ，结果会以扩展模式显示。如果在命令名后追加 + ，则会显示每个函数的附加信息，包括易变性、并行安全性、所有者、安全分类、是否防漏、访问权限、语言、内部名称（仅适用于 C 和 internal 函数）以及描述。特定函数的源代码可通过 \\sf 查看。","description_zh_html":"\u003cdd\u003e\u003cp\u003e\n        列出函数，以及它们的结果数据类型、参数数据类型和函数类型，函数类型分为\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eagg\u003c/span\u003e”\u003c/span\u003e（聚合）、\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003enormal\u003c/span\u003e”\u003c/span\u003e、\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eprocedure\u003c/span\u003e”\u003c/span\u003e、\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003etrigger\u003c/span\u003e”\u003c/span\u003e或\u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ewindow\u003c/span\u003e”\u003c/span\u003e。要只显示特定类型的函数，请在命令后添加相应的字母 \u003ccode class=\"literal\"\u003ea\u003c/code\u003e、\u003ccode class=\"literal\"\u003en\u003c/code\u003e、\u003ccode class=\"literal\"\u003ep\u003c/code\u003e、\u003ccode class=\"literal\"\u003et\u003c/code\u003e 或 \u003ccode class=\"literal\"\u003ew\u003c/code\u003e。如果指定了 \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e，则只显示名称与模式匹配的函数。任何附加参数都是类型名模式，分别与函数第一、第二等参数的类型名匹配。（匹配到的函数可以比你指定的参数更多；若要防止这种情况，可将连字符 \u003ccode class=\"literal\"\u003e-\u003c/code\u003e 写成最后一个 \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e。）默认情况下，只显示用户创建的对象；提供模式或 \u003ccode class=\"literal\"\u003eS\u003c/code\u003e\n        修饰符可包括系统对象。如果在命令名后追加 \u003ccode class=\"literal\"\u003ex\u003c/code\u003e，结果会以扩展模式显示。如果在命令名后追加 \u003ccode class=\"literal\"\u003e+\u003c/code\u003e，则会显示每个函数的附加信息，包括易变性、并行安全性、所有者、安全分类、是否防漏、访问权限、语言、内部名称（仅适用于 C 和 internal 函数）以及描述。特定函数的源代码可通过 \u003ccode class=\"literal\"\u003e\\sf\u003c/code\u003e 查看。\n        \u003c/p\u003e\u003c/dd\u003e","documentation_revision":{"inputs":[{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","version":"18.7"},{"file":"app-psql.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"cb475c53a16d9e06358f5e6c9c5649645db92568cfd319f230c62c9f57ae090b","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"},"facts":[{"label":"Client","value":"psql 18.7"},{"label":"Case-sensitive spelling","value":"\\df"}],"facts_zh":[{"label":"客户端","value":"psql 18.7"},{"label":"区分大小写的写法","value":"\\df"}],"localization":{"documentation_release":"18.7","language":"en","source_language":"en","source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552","status":"same-version-reviewed-manual"},"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DF-LC\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\df[anptwSx+] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e ... ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists functions, together with their result data types, argument data\n        types, and function types, which are classified as \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eagg\u003c/span\u003e”\u003c/span\u003e\n        (aggregate), \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003enormal\u003c/span\u003e”\u003c/span\u003e, \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eprocedure\u003c/span\u003e”\u003c/span\u003e, \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003etrigger\u003c/span\u003e”\u003c/span\u003e, or \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ewindow\u003c/span\u003e”\u003c/span\u003e.\n        To display only functions\n        of specific type(s), add the corresponding letters \u003ccode class=\"literal\"\u003ea\u003c/code\u003e,\n        \u003ccode class=\"literal\"\u003en\u003c/code\u003e, \u003ccode class=\"literal\"\u003ep\u003c/code\u003e, \u003ccode class=\"literal\"\u003et\u003c/code\u003e, or \u003ccode class=\"literal\"\u003ew\u003c/code\u003e to the command.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only\n        functions whose names match the pattern are shown.\n        Any additional arguments are type-name patterns, which are matched\n        to the type names of the first, second, and so on arguments of the\n        function.  (Matching functions can have more arguments than what\n        you specify.  To prevent that, write a dash \u003ccode class=\"literal\"\u003e-\u003c/code\u003e as\n        the last \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e.)\n        By default, only user-created\n        objects are shown; supply a pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e\n        modifier to include system objects.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name, additional information\n        about each function is shown, including volatility,\n        parallel safety, owner, security classification, whether it is\n        leakproof, access privileges, language, internal name (for C and\n        internal functions only), and description.\n        Source code for a specific function can be seen\n        using \u003ccode class=\"literal\"\u003e\\sf\u003c/code\u003e.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DF-LC","modifiers":[{"command":"\\df","modifiers":"anptwSx+"}],"related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"related_zh":[{"label":"psql 命令行选项及完整手册","url":"/wiki/tool/psql/?v=18"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sections":[],"sections_zh":[],"signature":"\\df[anptwSx+] [ pattern [ arg_pattern ... ] ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DF-LC","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DF-LC"}],"spellings":["\\df"],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\df","url":"/wiki/psql/cmd-64-66/?v=18"},"modifiers":"anptwSx+"}],"title":"Spellings in this manual definition"}],"tables_zh":[{"columns":[{"key":"command","label":"命令"},{"key":"modifiers","label":"手册中的后缀修饰符"}],"key":"spellings","rows":[{"command":{"text":"\\df","url":"/wiki/psql/cmd-64-66/?v=18"},"modifiers":"anptwSx+"}],"title":"本版手册中的写法"}],"zh_from":"same-version-manual"},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DF-LC","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.7","major":"18","manifest":{"major":"18","release":"18.7","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd","source_url":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2"},"ref":"https://ftp.postgresql.org/pub/source/v18.7/postgresql-18.7.tar.bz2","revision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","source_sha256":"441dfae4280cae3e0425e5f876f80559fb0731c140f1aae22b3e5a54d0411bfd"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-DF-LC","file":"app-psql.html","label":"18.7 English manual · app-psql.html","sha256":"af50448485df02bdef2b72b8347192ba029c7082b8d0392ecb17db44ad533aaf","url":"/docs/18/app-psql.html#APP-PSQL-META-COMMAND-DF-LC"}]},"MeasuredEvidence":{}},"Text":{"Collection":"psql","Key":"cmd-64-66","SourceDatabase":"center","Version":"18","Locale":"en","Title":"\\df","Summary":"Lists functions, together with their result data types, argument data types, and function types, which are classified as “ agg ” (aggregate), “ normal ” , “ procedure ” , “ trigger ” , or “ window ” . To display only functions of specific type(s), add the corresponding letters a , n , p , t , or w to the command. If pattern is specified, only functions whose names match the pattern are shown. Any additional arguments are type-name patterns, which are matched to the type names of the first, second, and so on arguments of the function. (Matching functions can have more arguments than what you specify. To prevent that, write a dash - as the last arg_pattern .) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each function is shown, including volatility, parallel safety, owner, security classification, whether it is leakproof, access privileges, language, internal name (for C and internal functions only), and description. Source code for a specific function can be seen using \\sf .","BodyHTML":"\u003cdiv\u003e\u003cdl\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DF-LC\"\u003e\u003cspan\u003e\u003ccode\u003e\\df[anptwSx+] [ \u003ca href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\" rel=\"nofollow\"\u003e\u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003cem\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e ... ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists functions, together with their result data types, argument data\n        types, and function types, which are classified as \u003cspan\u003e“\u003cspan\u003eagg\u003c/span\u003e”\u003c/span\u003e\n        (aggregate), \u003cspan\u003e“\u003cspan\u003enormal\u003c/span\u003e”\u003c/span\u003e, \u003cspan\u003e“\u003cspan\u003eprocedure\u003c/span\u003e”\u003c/span\u003e, \u003cspan\u003e“\u003cspan\u003etrigger\u003c/span\u003e”\u003c/span\u003e, or \u003cspan\u003e“\u003cspan\u003ewindow\u003c/span\u003e”\u003c/span\u003e.\n        To display only functions\n        of specific type(s), add the corresponding letters \u003ccode\u003ea\u003c/code\u003e,\n        \u003ccode\u003en\u003c/code\u003e, \u003ccode\u003ep\u003c/code\u003e, \u003ccode\u003et\u003c/code\u003e, or \u003ccode\u003ew\u003c/code\u003e to the command.\n        If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only\n        functions whose names match the pattern are shown.\n        Any additional arguments are type-name patterns, which are matched\n        to the type names of the first, second, and so on arguments of the\n        function.  (Matching functions can have more arguments than what\n        you specify.  To prevent that, write a dash \u003ccode\u003e-\u003c/code\u003e as\n        the last \u003cem\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e.)\n        By default, only user-created\n        objects are shown; supply a pattern or the \u003ccode\u003eS\u003c/code\u003e\n        modifier to include system objects.\n        If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode\u003e+\u003c/code\u003e is appended to the command name, additional information\n        about each function is shown, including volatility,\n        parallel safety, owner, security classification, whether it is\n        leakproof, access privileges, language, internal name (for C and\n        internal functions only), and description.\n        Source code for a specific function can be seen\n        using \u003ccode\u003e\\sf\u003c/code\u003e.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915","ContentHash":"ab0bdad757b7d52312cd2b01952f25bc1c1cd32efb274dcf37e6a542a68c3715","Payload":{"description":["Lists functions, together with their result data types, argument data types, and function types, which are classified as “ agg ” (aggregate), “ normal ” , “ procedure ” , “ trigger ” , or “ window ” . To display only functions of specific type(s), add the corresponding letters a , n , p , t , or w to the command. If pattern is specified, only functions whose names match the pattern are shown. Any additional arguments are type-name patterns, which are matched to the type names of the first, second, and so on arguments of the function. (Matching functions can have more arguments than what you specify. To prevent that, write a dash - as the last arg_pattern .) By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, additional information about each function is shown, including volatility, parallel safety, owner, security classification, whether it is leakproof, access privileges, language, internal name (for C and internal functions only), and description. Source code for a specific function can be seen using \\sf ."],"manual_html":"\u003cdiv\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt id=\"APP-PSQL-META-COMMAND-DF-LC\"\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003e\\df[anptwSx+] [ \u003ca class=\"link\" href=\"/docs/18/app-psql.html#APP-PSQL-PATTERNS\" title=\"Patterns\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e\u003c/a\u003e [ \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e ... ] ]\u003c/code\u003e\u003c/span\u003e \u003c/dt\u003e\u003cdd\u003e\u003cp\u003e\n        Lists functions, together with their result data types, argument data\n        types, and function types, which are classified as \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eagg\u003c/span\u003e”\u003c/span\u003e\n        (aggregate), \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003enormal\u003c/span\u003e”\u003c/span\u003e, \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eprocedure\u003c/span\u003e”\u003c/span\u003e, \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003etrigger\u003c/span\u003e”\u003c/span\u003e, or \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003ewindow\u003c/span\u003e”\u003c/span\u003e.\n        To display only functions\n        of specific type(s), add the corresponding letters \u003ccode class=\"literal\"\u003ea\u003c/code\u003e,\n        \u003ccode class=\"literal\"\u003en\u003c/code\u003e, \u003ccode class=\"literal\"\u003ep\u003c/code\u003e, \u003ccode class=\"literal\"\u003et\u003c/code\u003e, or \u003ccode class=\"literal\"\u003ew\u003c/code\u003e to the command.\n        If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e is specified, only\n        functions whose names match the pattern are shown.\n        Any additional arguments are type-name patterns, which are matched\n        to the type names of the first, second, and so on arguments of the\n        function.  (Matching functions can have more arguments than what\n        you specify.  To prevent that, write a dash \u003ccode class=\"literal\"\u003e-\u003c/code\u003e as\n        the last \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e.)\n        By default, only user-created\n        objects are shown; supply a pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e\n        modifier to include system objects.\n        If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results\n        are displayed in expanded mode.\n        If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e is appended to the command name, additional information\n        about each function is shown, including volatility,\n        parallel safety, owner, security classification, whether it is\n        leakproof, access privileges, language, internal name (for C and\n        internal functions only), and description.\n        Source code for a specific function can be seen\n        using \u003ccode class=\"literal\"\u003e\\sf\u003c/code\u003e.\n        \u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","related":[{"label":"psql command-line options and complete manual","url":"/wiki/tool/psql/?v=18"}],"sections":[],"tables":[{"columns":[{"key":"command","label":"Command"},{"key":"modifiers","label":"Documented suffix modifiers"}],"key":"spellings","rows":[{"command":{"text":"\\df","url":"/wiki/psql/cmd-64-66/?v=18"},"modifiers":"anptwSx+"}],"title":"Spellings in this manual definition"}]}},"RequestedLocale":"en","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\df","Signature":"\\df[anptwSx+] [ pattern [ arg_pattern ... ] ]","Modifiers":[{"command":"\\df","modifiers":"anptwSx+"}]}],"SQLState":null,"Evidence":null}