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

1 vote112 views1 answer
Sql insert for each distinct value
SQL
11 votes123 views1 answer
Ddl materialized view
SQL
0 vote118 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote143 views1 answer
Linux upload database to mysql
SQL
4 votes125 views1 answer
Mac install mysql
SQL
4 votes100 views1 answer
Sql list users and roles
SQL
0 vote140 views1 answer
Sql query inline if
SQL
1 vote126 views1 answer
Postgres convert exisiting column to text
SQL
15 votes203 views3 answers
Postgresql change column type
SQL
2 votes120 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL