Logo
BEAUTY IN SIMPLE
Katsiaryna (Kate) Lupachova

Katsiaryna (Kate) Lupachova

Mobile and web apps developer, freelancer based in Belarus (Europe).

Europe Map
2019 - 2021 © 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 Jun. 2021
PostgreSQL
last updated Oct. 2020
React
last updated Oct. 2020
VS Code
last updated Oct. 2020
Netlify
last updated Jan. 2021

title: "PostgreSQL"

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.