{"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","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":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","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 ."],"facts":[{"label":"Client","value":"psql 18.6"},{"label":"Case-sensitive spelling","value":"\\df"}],"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\n\u003cp\u003eLists functions, together with their result data types, argument data types, and function types, which are classified as \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eagg\u003c/span\u003e”\u003c/span\u003e (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. To display only functions of specific type(s), add the corresponding letters \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, or \u003ccode class=\"literal\"\u003ew\u003c/code\u003e to the command. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003e-\u003c/code\u003e as the last \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e.) By default, only user-created objects are shown; supply a pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e modifier to include system objects. If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e 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 \u003ccode class=\"literal\"\u003e\\sf\u003c/code\u003e.\u003c/p\u003e\n\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"}],"release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[],"signature":"\\df[anptwSx+] [ pattern [ arg_pattern ... ] ]","sources":[{"anchor":"APP-PSQL-META-COMMAND-DF-LC","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","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"}]},"ManualEvidence":{"manual_path":"app-psql.html#APP-PSQL-META-COMMAND-DF-LC","release":{"channel":"stable","evidence_kind":"English manual and source declarations","label":"18.6","major":"18","manifest":{"index":"index.html","major":"18","pages":1148,"pdf":{"A4":{"built_at":"2026-09-26","bytes":15865106,"pages":3154,"sha256":"19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190","url":"/files/documentation/pdf/18/postgresql-18-A4.pdf"},"US":{"built_at":"2026-09-26","bytes":15748059,"pages":3328,"sha256":"facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319","url":"/files/documentation/pdf/18/postgresql-18-US.pdf"}},"release":"18.6","source_mode":"en SGML built with pinned official archive","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","svg_assets":3,"tree":"18"},"ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"anchor":"APP-PSQL-META-COMMAND-DF-LC","file":"app-psql.html","label":"18.6 English manual · app-psql.html","sha256":"fa2a1d39294b8854318e82e93f71272c645ed88150ecc2786c28902c3f32782c","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\n\u003cp\u003eLists functions, together with their result data types, argument data types, and function types, which are classified as \u003cspan\u003e“\u003cspan\u003eagg\u003c/span\u003e”\u003c/span\u003e (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. To display only functions of specific type(s), add the corresponding letters \u003ccode\u003ea\u003c/code\u003e, \u003ccode\u003en\u003c/code\u003e, \u003ccode\u003ep\u003c/code\u003e, \u003ccode\u003et\u003c/code\u003e, or \u003ccode\u003ew\u003c/code\u003e to the command. If \u003cem\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e 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 \u003ccode\u003e-\u003c/code\u003e as the last \u003cem\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e.) By default, only user-created objects are shown; supply a pattern or the \u003ccode\u003eS\u003c/code\u003e modifier to include system objects. If \u003ccode\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode\u003e+\u003c/code\u003e 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 \u003ccode\u003e\\sf\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","SourceRevision":"ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8","ContentHash":"815cf738ae1bc7f67711a4f9c296c94bf123dbf9a0914eddd91741db48ee9a1b","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\n\u003cp\u003eLists functions, together with their result data types, argument data types, and function types, which are classified as \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eagg\u003c/span\u003e”\u003c/span\u003e (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. To display only functions of specific type(s), add the corresponding letters \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, or \u003ccode class=\"literal\"\u003ew\u003c/code\u003e to the command. If \u003cem class=\"replaceable\"\u003e\u003ccode\u003epattern\u003c/code\u003e\u003c/em\u003e 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 \u003ccode class=\"literal\"\u003e-\u003c/code\u003e as the last \u003cem class=\"replaceable\"\u003e\u003ccode\u003earg_pattern\u003c/code\u003e\u003c/em\u003e.) By default, only user-created objects are shown; supply a pattern or the \u003ccode class=\"literal\"\u003eS\u003c/code\u003e modifier to include system objects. If \u003ccode class=\"literal\"\u003ex\u003c/code\u003e is appended to the command name, the results are displayed in expanded mode. If \u003ccode class=\"literal\"\u003e+\u003c/code\u003e 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 \u003ccode class=\"literal\"\u003e\\sf\u003c/code\u003e.\u003c/p\u003e\n\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":"zh-Hans","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":[{"Version":"18","Ordinal":0,"Command":"\\df","Signature":"\\df[anptwSx+] [ pattern [ arg_pattern ... ] ]","Modifiers":[{"command":"\\df","modifiers":"anptwSx+"}]}],"SQLState":null,"Evidence":null}