\df

说明

列出函数，以及它们的结果数据类型、参数数据类型和函数类型，函数类型分为 “ agg ” （聚合）、 “ normal ” 、 “ procedure ” 、 “ trigger ” 或 “ window ” 。要只显示特定类型的函数，请在命令后添加相应的字母 a 、 n 、 p 、 t 或 w 。如果指定了 pattern ，则只显示名称与模式匹配的函数。任何附加参数都是类型名模式，分别与函数第一、第二等参数的类型名匹配。（匹配到的函数可以比你指定的参数更多；若要防止这种情况，可将连字符 - 写成最后一个 arg_pattern 。）默认情况下，只显示用户创建的对象；提供模式或 S 修饰符可包括系统对象。如果在命令名后追加 x ，结果会以扩展模式显示。如果在命令名后追加 + ，则会显示每个函数的附加信息，包括易变性、并行安全性、所有者、安全分类、是否防漏、访问权限、语言、内部名称（仅适用于 C 和 internal 函数）以及描述。特定函数的源代码可通过 \sf 查看。

客户端

psql 18.6

区分大小写的写法

\df

用法

\df[anptwSx+] [ pattern [ arg_pattern ... ] ]

相关条目

• psql 命令行选项及完整手册

文档与源码

• 18.6 English manual · app-psql.html

版本比较

PostgreSQL 17 → 18: 属性变化。

以下差异保留原始字段名与英文源描述。

--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1,12 +1,12 @@
 {
-  "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 the form \\df+ is used, additional information about each function is shown, including volatility, parallel safety, owner, security classification, 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": "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": "anptwS+"
+      "modifiers": "anptwSx+"
     }
   ],
-  "signature": "\\df[anptwS+] [ pattern [ arg_pattern ... ] ]",
+  "signature": "\\df[anptwSx+] [ pattern [ arg_pattern ... ] ]",
   "spellings": [
     "\\df"
   ]

比较已记录的接口与属性，排除来源指纹和构建元数据。某个样本中没有记录，不能据此判断实际引入或移除的版本。

相关条目

• \d
• \dA
• \dAc
• \dAf
• \dAo
• \dAp
• \dC
• \dD
• \dE
• \dF
• \dFd
• \dFp