List roles

sql

\du

Explanation

Useful when checking login capability, superuser privileges, or group roles.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Connect and Inspect with psql

Open an interactive psql session to a database.

Open In sheetbashsame section

Connect using a full PostgreSQL connection string.

Open In sheetbashsame section

Show all databases in the cluster.

Open In sheetsqlsame section

Show schemas in the current database.

Open In sheetsqlsame section

List relations across schemas.

Open In sheetsqlsame section

Show columns, indexes, defaults, storage details, and more for a relation.

Open In sheetsqlsame section