how to create a new database in postgresql 10?
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 .