Create a database on PostgreSQL via a command line

Question

I'm trying to create database in psql via CLI.

psql  -U postgres createdb portal

I kept getting

psql: warning: extra command-line argument "portal" ignored
psql: FATAL:  database "createdb" does not exist

What did I do wrong ?

Note

I'm not trying to queries any data.

I'm not trying to query from a command line, I'm trying to create a database. That answer is NOT what I am looking for. Please kindly unmark it. — code-8
– code-8, Commented Jun 21, 2016 at 15:23
Finally, someone know what I am trying to do. Thanks @code_onkel — code-8
– code-8, Commented Jun 21, 2016 at 15:33
@code_onkel : Your suggestions works perfectly. Please answer it, you deserve it. :) — code-8
– code-8, Commented Jun 21, 2016 at 15:34

Vao Tsun · Accepted Answer · 2016-06-21 15:32:34Z

6

here I connect as user vao to database postgres (which always is there) and create database db1 in CLI... The first argument without key is database name, so in your example createdb is interpreted as dbname to connect to...

please look at documentation of psql

Vaos-MacBook-Air:tts vao$ bash -c "psql -U vao postgres -c 'create database db1;'"
CREATE DATABASE

answered Jun 21, 2016 at 15:32

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

Collectives™ on Stack Overflow

Create a database on PostgreSQL via a command line

Note

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

Note

1 Answer 1

Comments

Related