PostgreSQL meta-commands

From wikieduonline
Jump to navigation Jump to search

https://www.postgresql.org/docs/current/app-psql.html

\du          List users
\du+
\dg
\ddp
\dp           Lists tables, views and sequences with their associated access privileges
\dp *.*
\list
\dn           Lists schemas (namespaces)
\dn+
\dt
\c
\l
\di
\dE[S+] [ pattern ] foreign table
\di[S+] [ pattern ] index
\dm[S+] [ pattern ] materialized view
\ds[S+] [ pattern ] sequence
\dt[S+] [ pattern ] table
\dv[S+] [ pattern ] view

Related

See also

Advertising: