all about postgres

postgres.md

Connect

psql -U postgres

Create Db

CREATE DATABASE my_test_db

List Db

\l

Use Db

\c my_test_db

List Tables

\d

Alter Table

ALTER TABLE table_name ADD COLUMN IF NOT EXISTS column_name INTEGER;

ALTER TABLE table_name DROP COLUMN IF EXISTS column_name;

Constraints at DB Level

https://www.scaler.com/topics/postgresql/table-level-constraints-in-postgresql/
https://www.prisma.io/dataguide/postgresql/column-and-table-constraints