Create PostgreSQL Database & User

Create a PostgreSQL database and a dedicated user with full rights on it.

Creates a PostgreSQL role (user) and a database owned by that role using psql commands. PostgreSQL security model differs from MySQL - roles have specific privilege sets.

When you need this: When setting up a new application that needs its own PostgreSQL credentials.