postgres.md

User Management

-- display users
\du

-- change user password
\password 'USER_NAME'

Database Management

-- create DB
CREATE DATABASE db_name;

-- drop database
DROP DATABASE db_name;

-- create user with password
CREATE USER some_username WITH PASSWORD 'password';

Navigation

-- quit CLI
\q