grant new user to database postgre
danang setya pramanaGRANT CONNECT ON DATABASE mydatabase TO myuser; GRANT USAGE ON SCHEMA public TO myuser; GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA public TO myuser;
postgre SQL Connection String
have 2 version of it postgres://username:password@127.0.0.1:5432/dbname AND postgresql://username:password@127.0.0.1:5432/dbname