Schema exploration in Postgres

Help

Help on some statements:

\h ALTER TABLE

Connect to the database:

psql -d my_db

# or

\c my_db

Enable query time reporting:

\timing

Nice formatting:

\x

Command history:

\s

List databases:

\l

List databases with details:

\l+

Show tables:

\dt

Show tables from another schema:

\dt sales.*

Describe a table, including columns and data types:

\d saltes.address

List schemas:

\dn

List index:

\di sales.*

List views:

\dv views

List functions:

\df functions

List users:

\du users

List groups:

\dg groups