psql -h postgres -p 5432 -U username -d postgres

CREATE DATABASE test_database;

\c test_database
\connect test_database

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

# \dt
         List of relations
 Schema | Name  | Type  |  Owner   
--------+-------+-------+----------
 public | users | table | username
(1 row)

INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');

SELECT * FROM users;
 id | name  |       email       
----+-------+-------------------
  1 | Alice | alice@example.com
(1 row)

UPDATE users SET name = 'Alice Smith' WHERE id = 1;

SELECT * FROM users;
 id |    name     |       email       
----+-------------+-------------------
  1 | Alice Smith | alice@example.com

DELETE FROM users WHERE id = 1;

SELECT * FROM users;
 id | name | email 
----+------+-------
(0 rows)