Question: how to create spatial database in postgresql?
Answer: Open pgAdmin 4. ... 
Double-click on that server to open a connection to it. ... 
Expand the Databases list. ... 
Right-click on the Databases list, and choose Create > Database.
In the Create - Database dialog, set the Database to Lesson3db, and from the Owner list, select the postgres user name.