Useradd postgres

Psql create user

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

Useradd postgres

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

Source: medium.com

Similar codes

4 votes351 views1 answer
Create db table
SQL
0 vote363 views1 answer
Sql count * vs count 1
SQL
3 votes396 views1 answer
How to add unique constraint in mysql table
SQL
0 vote441 views1 answer
Jpa generationtype sequence mysql
SQL
1 vote335 views2 answers
Mysql spring boot application.properties
SQL
0 vote356 views1 answer
Populate db from command line postgres
SQL
0 vote366 views1 answer
Sql cmd no truncate
SQL
5 votes362 views5 answers
Sqlite install python
SQL
0 vote367 views2 answers
Add colum in sql
SQL
1 vote361 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL