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

5 votes210 views1 answer
Oracle sysdate
SQL
8 votes198 views1 answer
Sql limit results returned
SQL
-1 vote263 views3 answers
Error: mysql shutdown unexpectedly.
SQL
1 vote284 views1 answer
Sql oracle update multiple rows
SQL
0 vote220 views2 answers
Insert data mysql with cmd
SQL
2 votes224 views2 answers
Create temporary table in mysql
SQL
1 vote235 views1 answer
Postgres power
SQL
0 vote205 views1 answer
Addition of 2 column value in mysql
SQL
0 vote241 views1 answer
Oracle decode
SQL
0 vote277 views1 answer
Osm2pgsql mac
SQL