Drop Postgres User

drop_user.sql

-- (Optional) Change password to something unknown to the user
ALTER user my_user WITH PASSWORD 'delete-me';

-- Shift ownership of objects to another user
REASSIGN OWNED BY my_user TO postgres;

-- Drop any privledges granted to the user (not sure why this isn't done automatically)
DROP OWNED BY my_user;

-- Drop the user
DROP user my_user;