B. Postgres - miguemesen/Fullstack_tuto GitHub Wiki

To start postgres services

brew services start postgresql

---

To stop postgres services

brew services stop postgresql

---

Log into postgres server

psql postgres

---

Log into postgres server with user

psql postgres -U $userName$

---

List users and their roles

\du

---

Exit postgres

\q

---

List databases

\l+

---

Use database

\c $DB_Name$

---

Show DB tables

\dt+

---