How to create a user with PostgreSQL?

How to create a user with PostgreSQL? #postgres #database #user

Here is a quick tutorial for today using Postgresql on Command Line using a terminal in Linux:

sudo -u postgres createuser jammy
sudo -u postgres createdb my_local_db
sudo -u postgres psql (get into command line interface mode)
  1. ALTER USER jammy WITH PASSWORD ‘my_new_shiny_password’;
  2. GRANT ALL PRIVILEGES ON DATABASE my_local_db to jammy

Once you install the Postgres tool, the process should be the same with Windows and Mac.

You can also use free GUI tools such as:

  1. PGAdmin
  2. HeidiSQL (not cross-platform)
  3. DBWeaver
Abdallah Yashir

Senior Software Developer, Writer, Amateur Photographer, Reader