Wiki / psql Commands

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 .

Client

psql 18.7

Case-sensitive spelling

\df

command

\df

manual path

app-psql.html#APP-PSQL-META-COMMAND-DF-LC

modifiers

map[command:\df modifiers:anptwSx+]

signature

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

spellings

\df

{"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"}