Wiki / psql Commands / Describe database objects
\des
Lists foreign servers (mnemonic: “ external servers ” ). If pattern is specified, only those servers whose name matches the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the…
Reading PostgreSQL 18.6.
Description
Lists foreign servers (mnemonic: “ external servers ” ). If pattern is specified, only those servers whose name matches the pattern are listed. If x is appended to the command name, the results are displayed in expanded mode. If + is appended to the command name, a full description of each server is shown, including the server's access privileges, type, version, options, and description.
- Client
- psql 18.6
- Case-sensitive spelling
- \des
Usage
\des[x+] [ pattern ]Spellings in this manual definition
| Command | Documented suffix modifiers |
|---|---|
| \des | x+ |
Manual definition
\des[x+] [pattern]-
Lists foreign servers (mnemonic: “external servers”). If
patternis specified, only those servers whose name matches the pattern are listed. Ifxis appended to the command name, the results are displayed in expanded mode. If+is appended to the command name, a full description of each server is shown, including the server's access privileges, type, version, options, and description.
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 11 → 12: changed.
--- PostgreSQL 11
+++ PostgreSQL 12
@@ -1,5 +1,5 @@
{
- "definition": "Lists foreign servers (mnemonic: “ external servers ” ). If pattern is specified, only those servers whose name matches the pattern are listed. If the form \\des+ is used, a full description of each server is shown, including the server's ACL, type, version, options, and description.",
+ "definition": "Lists foreign servers (mnemonic: “ external servers ” ). If pattern is specified, only those servers whose name matches the pattern are listed. If the form \\des+ is used, a full description of each server is shown, including the server's access privileges, type, version, options, and description.",
"modifiers": [
{
"command": "\\des",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.