SQL

Crear bbdd

CREATE DATABASE “NAME”;

Modificar valores usuarios

ALTER ROLE usuario PASSWORD 'ContraseñaNueva';

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';

Crear usuario

CREATE USER myprojectuser WITH PASSWORD 'password';

Dar permisos

GRANT ALL PRIVILEGES ON DATABASE myproject TO myprojectuser;

Ver permisos

\l