create database in postgresql with bash command

Question

Im trying to create a database in postgresql using linux.
I connected to postgres with

sudo -u postgres psql postgres 
postgres=# then i tried **CREATE DATABASE demo** or **createdb demo**

but none of them worked when i checked with \l command.
Any help ?

What did you get as result of your CREATE DATABSE demo; ? You should have the message like : CREATE DATABASE and that's it ... so what said PostgreSQL ? — Hervé Piedvache
– Hervé Piedvache, Commented Oct 31, 2017 at 16:32
i got nothing...after i added quotes it created but i can't drop database now (just for testing) — pinug
– pinug, Commented Oct 31, 2017 at 16:38
You can't drop a database when you are connected to it ... but the command is simply DROP DATABASE demo; when you are corrected to postgres default database. — Hervé Piedvache
– Hervé Piedvache, Commented Oct 31, 2017 at 16:51

Vao Tsun · Accepted Answer · 2017-10-31 16:09:04Z

14

sudo su - postgres to become postgres

then psql -c "create database demo" to create it from shell

answered Oct 31, 2017 at 16:09

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

pinug Over a year ago

i added quotes it is worked but i can't drop database demo now :/ 5 (to test it)

omar ahmed · Accepted Answer · 2019-07-19 08:39:33Z

4

first:

    sudo su postgres

and then enter your password then type:

     psql

and type this command:

    CREATE DATABASE dbname;

answered Jul 19, 2019 at 8:39

omar ahmed

6636 silver badges20 bronze badges

1 Comment

user330315 Over a year ago

Or simply start psql -U postgres ...

mehdi mosavi · Accepted Answer · 2019-08-15 05:39:46Z

2

simple type on bash

$ createdb -U postgres(db user) dbname

if set hba_config in pg for access to db in network type

$ createdb -h YOUR_IP -U postgres(db user) dbname

if you set password for db user pg ask your password to create database

edited Aug 15, 2019 at 5:39

answered Aug 15, 2019 at 5:34

mehdi mosavi

193 bronze badges

Collectives™ on Stack Overflow

create database in postgresql with bash command

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related