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

1 vote258 views2 answers
How to check if sql query is correct online
SQL
1 vote248 views2 answers
Sql select only first occurrence
SQL
0 vote269 views1 answer
How to add timestamp column in mysql
SQL
0 vote267 views1 answer
Test sql query
SQL
0 vote257 views1 answer
Drop column from local database postgres pgadmin
SQL
12 votes287 views4 answers
How to check mysql version ubuntu
SQL
0 vote246 views1 answer
Postgresql conectar
SQL
5 votes312 views1 answer
Oracle ora-00054 find
SQL
0 vote227 views1 answer
Mysql does collate nopad recognize space
SQL
11 votes275 views3 answers
How to get last row of table in sql
SQL