\do
Lists operators with their operand and result types. If pattern is specified, only operators whose names match the pattern are listed. If one arg_pattern is specified, only prefix operators whose right argument's type name matches that pattern are listed. If two arg_pattern s are specified, only binary operators whose argument type names match those patterns are listed. (Alternatively, write - for the unused argument of a unary operator.) 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 operator is shown, including the name of the underlying function, and whether it is leakproof.
Reading PG 18·Select a recorded version
- Client
- psql 18.7
- Case-sensitive spelling
- \do
- command
- \do
- manual path
- app-psql.html#APP-PSQL-META-COMMAND-DO-LC
- modifiers
- map[command:\do modifiers:Sx+]
- signature
- \do[Sx+] [ pattern [ arg_pattern [ arg_pattern ] ] ]
- spellings
- \do
Definition PG 18
\do[Sx+] [pattern[arg_pattern[arg_pattern] ] ]Lists operators with their operand and result types. If
patternis specified, only operators whose names match the pattern are listed. If onearg_patternis specified, only prefix operators whose right argument's type name matches that pattern are listed. If twoarg_patterns are specified, only binary operators whose argument type names match those patterns are listed. (Alternatively, write-for the unused argument of a unary operator.) By default, only user-created objects are shown; supply a pattern or theSmodifier to include system objects. Ifxis appended to the command name, the results are displayed in expanded mode. If+is appended to the command name, additional information about each operator is shown, including the name of the underlying function, and whether it is leakproof.
Exact case-sensitive spellings
\do
Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \do | Sx+ |
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