psql#

list databases#

\l

connect to a database#

\c <database_name>

list database tables#

\dt

describe a table#

\d <table_name>
\d+ <table_name> # verbose output

list database schemas#

\dn

list users#

\du
\du <username> # specific user

list functions#

\df

show a function#

\sf <function_name>

edit a function#

\ef <function_name>

list views#

\dv

list installed extensions#

\dx

toggle extended display#

\x

quit psql#

\q