Psql create user

Create db user postgres

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

How to create a new user in postgresql

CREATE DATABASE yourdbname;CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;

Source: medium.com

Psql create user

# https://www.postgresql.org/docs/8.0/sql-createuser.html
CREATE USER <username> WITH PASSWORD '<password>' VALID UNTIL '<date here>';

Create new user in postgres

CREATE USER visualscrapy WITH PASSWORD '123456';
# it will create the new user in postgres

How do I add a user to a postgres database? cli

psql=# grant all privileges on database <dbname> to <username>

Source: medium.com

Similar codes

0 vote61 views1 answer
Querry mysql by 2 columns
SQL
0 vote58 views1 answer
Sql select min row
SQL
0 vote52 views1 answer
Set column in all row mysql
SQL
0 vote50 views1 answer
Access mysql database docker container shell
SQL
0 vote73 views1 answer
Postgresql powershell query
SQL
0 vote49 views3 answers
Sql parenthetical expression examples
SQL
0 vote49 views1 answer
Resulting Query
SQL
0 vote50 views1 answer
Mysql add to value
SQL
0 vote53 views1 answer
Number(10 2) in sql means
SQL
0 vote56 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL