postgres cmd commands for windows

CREATE DATABASE

Postgres=#  create database databasenane;

CREATE BOLE

Postgres=#  create user testuser with password ‘password’ ;

ALTEB ROLE/CHANGE PASSWORD

Postgres=#  alter user testuser with password ‘newpassword’ ;

GRANT PRIVILEGES

Postgres=#  grant all privileges on database databasenane to testuser;