Psql create database

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;

Similar codes

4 votes198 views1 answer
Sql delete where in select
SQL
0 vote214 views2 answers
How to find max and min salary in sql
SQL
0 vote239 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote212 views1 answer
Select even number id data from table
SQL
0 vote237 views1 answer
List all permissions on a table in postgres
SQL
1 vote215 views1 answer
Count mysql server db tables
SQL
2 votes200 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote209 views2 answers
Postgres another version
SQL
0 vote212 views1 answer
Display first three characters sql
SQL
0 vote271 views3 answers
Mysql keyword search
SQL