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

4 votes108 views1 answer
Mysql ip address data type
SQL
0 vote99 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote116 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
1 vote96 views1 answer
Psql lst trigger
SQL
3 votes118 views1 answer
Export postgres database linux
SQL
1 vote106 views1 answer
Sql drop with dependencies
SQL
2 votes161 views5 answers
Install postgresql 10 centos 7
SQL
16 votes108 views3 answers
Jwt secret key generator laravel
SQL
1 vote117 views1 answer
Sql select whole row max column
SQL
0 vote108 views1 answer
Querry mysql by 2 columns
SQL