Question: how to create local database in postgresql in windows?
Answer: Download and install a PostgreSQL server. ...  Add the PostgreSQL bin directory path to the PATH environmental variable. ...  Open the psql command-line tool: ...  Run a CREATE DATABASE command to create a new database. ...  Connect to the new database using the command: \c databaseName. Run the postgres.