bash

Use createdb instead of psql for creating databases

PostgreSQL ships with createdb — a CLI wrapper around CREATE DATABASE. No need to open a psql session or remember the SQL syntax. It uses your system user by default, same as psql.

createdb my_nice_db

# instead of:
# psql -c "CREATE DATABASE my_nice_db;"
lubosmato