Little cheatsheet for Azure Database for PostgreSQL

azure-cli-postgres.md

Create an "Azure Database for PostgreSQL"

az postgres server create --resource-group {resource_group} `
                          --name {server_name} `
                          --admin-user master `
                          --admin-password {password} `
                          --location westeurope `
                          --version 11 `
                          --sku-name B_Gen5_1 `
                          --storage-size 5120

In order to setup a database, user and password just execute the following commands:

CREATE DATABASE "databaseName";
CREATE USER "userName" WITH PASSWORD 'passwordValue';
GRANT ALL PRIVILEGES ON DATABASE "userName" TO "databaseName";