PostgreSQL psql - Informational (PART 10 of 12)

PostgreSQL psql - Informational

a. (options: S = show system objects, + = additional detail)
b. \d[S+] list tables, views, and sequences
c. \d[S+] NAME describe table, view, sequence, or index
d. \da[S] [PATTERN] list aggregates
e. \dA[+] [PATTERN] list access methods
f. \db[+] [PATTERN] list tablespaces
g. \dc[S+] [PATTERN] list conversions
h. \dC[+] [PATTERN] list casts
i. \dd[S] [PATTERN] show object descriptions not displayed elsewhere
j. \dD[S+] [PATTERN] list domains
k. \ddp [PATTERN] list default privileges
l. \dE[S+] [PATTERN] list foreign tables
m. \det[+] [PATTERN] list foreign tables
n. \des[+] [PATTERN] list foreign servers
o. \deu[+] [PATTERN] list user mappings
p. \dew[+] [PATTERN] list foreign-data wrappers
q. \df[anptw][S+] [PATRN] list [only agg/normal/procedures/trigger/window] functions
r. \dF[+] [PATTERN] list text search configurations
s. \dFd[+] [PATTERN] list text search dictionaries
t. \dFp[+] [PATTERN] list text search parsers
u. \dFt[+] [PATTERN] list text search templates
v. \dg[S+] [PATTERN] list roles
w. \di[S+] [PATTERN] list indexes
x. \dl list large objects, same as \lo_list
y. \dL[S+] [PATTERN] list procedural languages
z. \dm[S+] [PATTERN] list materialized views
aa. \dn[S+] [PATTERN] list schemas
bb. \do[S] [PATTERN] list operators
cc. \dO[S+] [PATTERN] list collations
dd. \dp [PATTERN] list table, view, and sequence access privileges
ee. \drds [PATRN1 [PATRN2]] list per-database role settings
ff. \dRp[+] [PATTERN] list replication publications
gg. \dRs[+] [PATTERN] list replication subscriptions
hh. \ds[S+] [PATTERN] list sequences
ii. \dt[S+] [PATTERN] list tables
jj. \dT[S+] [PATTERN] list data types
kk. \du[S+] [PATTERN] list roles
ll. \dv[S+] [PATTERN] list views
mm. \dx[+] [PATTERN] list extensions
nn. \dy [PATTERN] list event triggers
oo. \l[+] [PATTERN] list databases
pp. \sf[+] FUNCNAME show a function's definition
qq. \sv[+] VIEWNAME show a view's definition
rr. \z [PATTERN] same as \dp