Wiki / psql Commands / Describe database objects
\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 l…
Reading PostgreSQL 18.6.
Description
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.
- Client
- psql 18.6
- Case-sensitive spelling
- \do
Usage
\do[Sx+] [ pattern [ arg_pattern [ arg_pattern ] ] ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \do | Sx+ |
Manual definition
\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.
Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8
Compare versions
PostgreSQL 17 → 18: changed.
--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1,12 +1,12 @@
{
- "definition": "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 + is appended to the command name, additional information about each operator is shown, currently just the name of the underlying function.",
+ "definition": "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.",
"modifiers": [
{
"command": "\\do",
- "modifiers": "S+"
+ "modifiers": "Sx+"
}
],
- "signature": "\\do[S+] [ pattern [ arg_pattern [ arg_pattern ] ] ]",
+ "signature": "\\do[Sx+] [ pattern [ arg_pattern [ arg_pattern ] ] ]",
"spellings": [
"\\do"
]Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
Export JSON · Back to psql Commands · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.