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

0 vote324 views1 answer
Sql show founctions
SQL
0 vote311 views1 answer
Reset postgres table index to next max value
SQL
0 vote300 views1 answer
Find how many tables in database sql query
SQL
4 votes316 views6 answers
List all tables in postgres
SQL
0 vote280 views1 answer
Drop all triggers oracle
SQL
1 vote305 views3 answers
How to update column name in psql
SQL
0 vote294 views1 answer
Automated psql csv export script on windows
SQL
0 vote290 views1 answer
Test sql query
SQL
0 vote369 views1 answer
What is common table expression in sql
SQL
0 vote265 views1 answer
Html css mobile menu arrow dropdown
SQL