List of useful Postgres commands

postgres_commands.sql

# Create database and user
CREATE DATABASE test_database;
CREATE USER tester WITH PASSWORD 'test_password';
GRANT ALL PRIVILEGES ON DATABASE "test_database" to tester;

# List all users
\du

# Delete a user with existing privileges
DROP OWNED BY <username>;
DROP USER <username>;

# Delete database
DROP DATABASE <db_name>;