Setup postgresql

CREATE DATABASE myprojectdb;
CREATE USER myprojectuser WITH PASSWORD 'strongpassword';
ALTER ROLE myprojectuser SET client_encoding TO 'UTF8';
ALTER ROLE myprojectuser SET default_transaction_isolation TO 'read committed';
ALTER ROLE myprojectuser SET timezone TO 'UTC';
GRANT ALL PRIVILEGES ON DATABASE myprojectdb TO myprojectuser;
\q

-- Connect to your DB
\c your_db_name

-- Take full control
ALTER SCHEMA public OWNER TO your_user_name;

-- Grant full schema access
GRANT ALL ON SCHEMA public TO your_user_name;

-- Ensure the user can create tables, etc.
GRANT ALL PRIVILEGES ON DATABASE your_db_name TO your_user_name;

-- Optional: Default privileges for new objects
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO your_user_name;