diff options
Diffstat (limited to 'Cheat sheets/Postgresql.md')
| -rw-r--r-- | Cheat sheets/Postgresql.md | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/Cheat sheets/Postgresql.md b/Cheat sheets/Postgresql.md deleted file mode 100644 index 084ad71..0000000 --- a/Cheat sheets/Postgresql.md +++ /dev/null @@ -1,24 +0,0 @@ ---- -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 - - |
