Question: how to create local database in postgresql?
Answer: Step 1) Open the SQL Shell.
Step 2) Press enter five times to connect to the DB.
Step 4) Enter command \l to get a list of all databases.
Step 1) In the Object Tree, right click and select create a database.
Step 4) The right pane gives you the SQL used to create the Database.