# Install PostgreSQL in Ubuntu 20.04

# Install PostgreSQL  in Ubuntu 20.04

## update system
```bash
sudo apt-get update
```

## install postgreSQL
```bash
sudo apt install postgresql postgresql-contrib
```

## open postgreSQL
```bash
sudo -i -u postgres psql
```

## close
```bash
 \q
```

## create new user
```bash
sudo -u postgres createuser --interactive
```

## create new database
```bash
sudo -u postgres createdb sammy
```

## add the new user in ubuntu 20.04
```bash
sudo adduser sammy
```

## change user password
```bash
sudo -u postgres psql

ALTER USER samy PASSWORD 'myPassword';

\q
```