Question: how to create a database in postgresql 9.6?
Answer: To create a database, you must be a superuser or have the special CREATEDB privilege. See CREATE USER. By default, the new database will be created by cloning the standard system database template1. A different template can be specified by writing TEMPLATE name.