Django PostgreSQL installation, database construction

■ Environment

Windows10home 　Python3.7 　PostgresSQL10.12

■ Installation / setting procedure

① PostgresSQL download and installation (omitted)

② Change environment variables

"Control Panel"-"System"-"Detailed System Settings" + "Environment Variables"

3Path edit PostgresQL added

④ Check the version of PSQL

　C:\python_project\venv_python_dev\Private_Diary_project>psql --version
psql (PostgreSQL) 10.12

■ Database creation

① psql login

psql -U postgres

C:\python_project\venv_python_dev\Private_Diary_project>psql -U postgres

② Database creation

create database　XXXXXXXXX;

postgres=# create database XXXXXXXXXXXXX_db;

CREATE DATABASE appears.

③ Check the database list. .. I want to

psql=# |　 I can't hear the vertical bar!

④ Get out of psql

psql=# \q

■ Install driver (psycopg2) for python connection

① pip installation

pip install psycopg2-binary

C:\python_project\venv_python_dev\Private_Diary_project>pip install psycopg2-binary

that's all