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

0 vote183 views1 answer
Import sql dump into postgresql database
SQL
37 votes252 views6 answers
Mysql update
SQL
0 vote186 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote176 views1 answer
Mysql max number not returning correct value
SQL
2 votes190 views1 answer
Where clause for child record apex
SQL
1 vote173 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote171 views1 answer
Alter table name including schema
SQL
5 votes178 views1 answer
Alter table add comment oracle
SQL
3 votes172 views2 answers
Oracle grants
SQL
0 vote202 views1 answer
Sql out file formate
SQL