\df[antw][S+] [PATRN] list [only agg/normal/trigger/window] functions \dF[+] [PATTERN] list text search configurations \dFd[+] [PATTERN] list text search dictionaries \dFp[+] [PATTERN] list text search parsers \dFt[+] [PATTERN] list text search templates \dg[+] [PATTERN] list rol...
learning | jarvis | UTF8 | C | UTF-8 | List all databases with additional information # \l+ List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges | Size | Tablespace | Description ---+---+---+---+---+---+---+---+--- learning | jarvis | UTF8...
\l[+] list all databases \z [PATTERN] same as \dp Formatting \a toggle between unaligned and aligned output mode \C [STRING] set table title, or unset if none \f [STRING] show or set field separator for unaligned query output \H toggle HTML output mode (currently off) \pset NAME ...
\drds [PATRN1 [PATRN2]] list per-database role settings \ds[S+] [PATTERN] list sequences \dt[S+] [PATTERN] list tables \dT[S+] [PATTERN] list data types \du[+] [PATTERN] list roles (users) \dv[S+] [PATTERN] list views \dE [PATTERN] list external tables \l[+] list all ...
List of databases -[ RECORD 1 ]---+--- Name | postgres Owner | postgres Encoding | UTF8 Collate | en_US.UTF-8 Ctype | en_US.UTF-8 Access privileges | -[ RECORD 2 ]---+--- Name | template0 Owner | postgres Encoding | UTF8 Collate | ...
\o [FILE] send all query results to file or |pipe \qecho [STRING] write string to query output stream (see \o)Informational (options: S = show system objects, + = additional detail)\d[S+] list tables, views, and sequences ...
postgres=# \l+ List of databases Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges---+---+---+---+---+---+---+---advent_of_code
List of databases Name | Owner | Encoding | Collate | Ctype | ICU Locale | Locale Provider | Access privileges ---+---+---+---+---+---+---+--- advent_of_code | postgres | UTF8 | en_US.utf8 | en_US.utf8 | | libc | postgres=CTc/postgres+ | | | | | | | rptusr=...
\dAo[+] [AMPTRN [OPFPTRN]] list operators of operator families \dAp[+] [AMPTRN [OPFPTRN]] list support functions of operator families \db[+] [PATTERN] list tablespaces \dc[S+] [PATTERN] list conversions \dconfig[+] [PATTERN] list configuration parameters ...
postgres=# \l+List of databases Name|Owner|Encoding|Collate|Ctype|ICU Locale|Locale Provider|Access privileges---+---+---+---+---+---+---+---advent_of_code|postgres|UTF8|en_US.utf8|en_US.utf8||libc|postgres=CTc/postgres+|||rptusr=c/postgres bulk_example|postgres|UTF8|en_...