pgcli¶

start pgcli¶

pgcli \d db_name

connect to db¶

\c db_name

list all schemas¶

\dn

list all tables¶

\dt schema.*

show details of table cols¶

\d schema.table_name

expanded mode¶

Show all columns from a query result without truncation. In this mode, each column value will be displayed on a new line, making it easier to view long values.

\x
\x off