/SQL/How to create a new user in postgresql

How to create a new user in postgresql

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>';

How to create new user and database postgresql in ubuntu

$ sudo -u postgres createdb <dbname>

Source: medium.com

How to create new user and database postgresql in ubuntu

$ sudo -u postgres psqlpsql=# alter user <username> with encrypted password '<password>';

Source: medium.com

Similar codes

0 vote598 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
-1 vote344 views1 answer
How to use update trigger in sql
SQL
0 vote353 views1 answer
Set mysql socket file docker windows
SQL
7 votes369 views2 answers
Oracle sql drop index
SQL
0 vote400 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote395 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote359 views1 answer
Insert output identity
SQL
0 vote382 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
-1 vote374 views1 answer
Phinehas Psalm 106
SQL
0 vote371 views1 answer
How to start my sql server on mac
SQL