Getting started with PostgreSQL on Ubuntu

sudo apt update
sudo apt install -y postgresql postgresql-contrib
sudo systemctl enable --now postgresql

sudo -u postgres createuser --interactive
sudo -u postgres createdb mydb

sudo -u postgres psql

\l  -- Datenbanken
\du -- Roles
\c db -- connect
\q  -- quit

CREATE TABLE celebs (
  id SERIAL PRIMARY KEY,
  name TEXT,
  age INT
);

INSERT INTO celebs (name, age) VALUES ('Justin Bieber', 22);
SELECT * FROM celebs;