\sf
This command fetches and shows the definition of the named function or procedure, in the form of a CREATE OR REPLACE FUNCTION or CREATE OR REPLACE PROCEDURE command. The definition is printed to the current query output channel, as set by \o .
Reading PG 18·Select a recorded version
- Client
- psql 18.7
- Case-sensitive spelling
- \sf
- command
- \sf
- manual path
- app-psql.html#APP-PSQL-META-COMMAND-SF
- modifiers
- map[command:\sf modifiers:+]
- signature
- \sf[+] function_description
- spellings
- \sf
Definition PG 18
\sf[+]function_descriptionThis command fetches and shows the definition of the named function or procedure, in the form of a
CREATE OR REPLACE FUNCTIONorCREATE OR REPLACE PROCEDUREcommand. The definition is printed to the current query output channel, as set by\o.The target function can be specified by name alone, or by name and arguments, for example
foo(integer, text). The argument types must be given if there is more than one function of the same name.If
+is appended to the command name, then the output lines are numbered, with the first line of the function body being line 1.Unlike most other meta-commands, the entire remainder of the line is always taken to be the argument(s) of
\sf, and neither variable interpolation nor backquote expansion are performed in the arguments.
Exact case-sensitive spellings
\sf
Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \sf | + |
Compare versions
Complete source facts
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"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915
Text language: en · 1b2d62b4845aa46374f2cb680f95d3392322cc8128646992ae4e18d0e7084915