\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 \
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 ...
\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[S+] [PATTERN] list roles \di[S+] [PATTERN] list indexes \dl list large objects, same as \...
\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 ...
\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
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 | ...
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=...
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_...