To create a PostgreSQL database is a simple process. You just need to log in to your cPanel -> PostgreSQL Databases.
In the Database Name: field, type your preferred database name and click the Create Database button. Note that the database will always include your cPanel username as a prefix for the selected database name.