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

0 vote175 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
15 votes185 views4 answers
T-sql drop function if exists
SQL
1 vote194 views1 answer
Sql to mongodb query converter
SQL
0 vote206 views1 answer
Oracle NLS_CHARACTERSET
SQL
2 votes195 views1 answer
Sql update alias
SQL
0 vote214 views1 answer
Selecting all columns from table sql database
SQL
0 vote182 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
6 votes190 views1 answer
Postgresql get year
SQL
1 vote207 views1 answer
Postgresql round double precision
SQL
0 vote209 views1 answer
Count columns psql(PostreSQL)
SQL