Linux & Postgres: createdb command use example

Trabla: create database using postgresql linux command tool - createdb

Solving:

sudo -u postgres  createdb -e -E UTF8 -O postgres moodle

where

sudo - u postgres      -   run command as user postgres
createdb         -  postgres linux command
-e                   - show echo - displays sql
-E UTF8        - encoding UTF8
-O postgres    - user owner of database
moodle          -  database name   

Example output:

CREATE DATABASE moodle OWNER postgres ENCODING 'UTF8';