diff options
| -rw-r--r-- | postgres.md | 11 |
1 files changed, 11 insertions, 0 deletions
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 <database> <user> + +### 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`. |