Create database postgres

Create postgres database

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

Create database postgres

createdb -h localhost -p 5432 -U postgres testdb
password ******

Source: tutorialspoint.com

Psql create database

# To create a new PostgreSQL database while using psql
CREATE DATABASE nameOfDatabase;

Source: grepper.com

Postgres create database

sudo su - postgres
psql -c "create database demo"

Source: grepper.com

Similar codes

3 votes121 views1 answer
Oracle revoke grant
SQL
0 vote120 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote130 views2 answers
Dbms interview questions
SQL
0 vote150 views1 answer
Postgres row expiration
SQL
2 votes166 views1 answer
Username sql
SQL
8 votes150 views3 answers
Find table for column name in sql
SQL
0 vote121 views1 answer
SQL SELECT-Klausel
SQL
1 vote126 views2 answers
T-sql random number for each row
SQL
4 votes182 views1 answer
Oracle change nls_date_format permanently
SQL
2 votes124 views1 answer
Sql column values comma separated
SQL