From 6f5372bba77f6c070df5ea46d19d95435b7d0f90 Mon Sep 17 00:00:00 2001 From: Marcin Chrzanowski Date: Tue, 26 May 2026 18:25:18 +0200 Subject: Add postgres commands --- postgres.md | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/postgres.md b/postgres.md index 28a0043..ddca2e5 100644 --- a/postgres.md +++ b/postgres.md @@ -2,6 +2,17 @@ Default user, db: `postgres` +## `psql` CLI + + psql + +### Meta commands + +- `\c[onnect]`: connects to a database, new server (can specify dbname, username, +host, port, etc., use `-` to leave unspecfied) +- `\dt`: list tables + - There's a bunch of complicated `\d*` commands + ## User management Everything should be done as user `postgres`. -- cgit v1.2.3