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 vote164 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
1 vote177 views1 answer
Store select query result in variable sql server
SQL
1 vote199 views1 answer
Sql server update column based on another table
SQL
0 vote178 views1 answer
Json_remove mysql
SQL
0 vote178 views1 answer
Postgresql get current user name
SQL
1 vote207 views1 answer
Mysql Case sum
SQL
0 vote214 views2 answers
What is the default password for sql server sa
SQL
3 votes232 views1 answer
Oracle nextval insert
SQL
0 vote197 views1 answer
Access mysql database docker container shell
SQL
2 votes212 views4 answers
How to find 2nd highest salary in mysql
SQL