Cheat sheets/Postgresql - Create database, user and grant permissions

1 files changed, 24 insertions, 0 deletions

diff --git a/Cheat sheets/Postgresql.md b/Cheat sheets/Postgresql.md
new file mode 100644
index 0000000..084ad71
--- /dev/null
+++ b/Cheat sheets/Postgresql.md
@@ -0,0 +1,24 @@
+---
+description: Create database, user and grant permissions
+created: 2023-12-21
+---
+
+## Create database, and user for login
+
+```bash
+sudo -u postgres psql
+```
+
+```sql
+CREATE DATABASE "database_name";
+CREATE ROLE "username";
+ALTER ROLE "username" WITH LOGIN;
+ALTER USER "username" WITH PASSWORD 'change_me';
+GRANT SELECT ON "table_name" TO "username";
+```
+
+> Replace `database_name`, `username`, `change_me` and `talbe_name`
+
+## DB backup / restore
+
+