Logo
BEAUTY IN SIMPLE
Katsiaryna (Kate) Lupachovaflag

Katsiaryna (Kate) Lupachova

Full-stack web developer, freelancer based in Belarus (Europe).

Europe Map
2019 - 2020 © All rights reserved.

Digital Garden

A collection of short solutions to daily tech problems, notes, some thoughts and explorations that might convert into a blog post someday. My take on Learn in public concept.

Heroku
last updated Oct. 2020
Git
last updated Oct. 2020
PostgreSQL
last updated Oct. 2020
React
last updated Oct. 2020
VS Code
last updated Oct. 2020
Netlify
last updated Jan. 2021

PostgreSQL

  1. Grant all privileges to user
  2. Connect to database by some user

Grant all privileges to user

  1. Connect to psql cli
psql -U <user>

Super user - postgres. You will be prompted to enter a password.

  1. Connect to database
c <database_name>
  1. Grant privileges
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public to <user_name>;
-----------------------------------------------------

Connect to database by some user

c <database_name> <user_name>

You will be prompted to enter a password.