For Windows Version
Link website for download postgre here.
For Linux Version
postgresql-contrib provides extra utilities and functionality.
postgresql-client package required to connect to, query, and manage a remote or local PostgreSQL database without running the database server itself.
sudo apt install postgresql postgresql-client postgresql-contrib
Related Links psql cheatsheet Setup Postgre untuk Odoo