postgresql create database tutorial

Question

I am following this tutorial for creating a user in postgresql.

It lists some commands to run, but does not say within what context to run them. I tried running the command psql,which takes me to a prompt like the following...

postgres=#

Then when I enter the commands shown in the tutorial there, absolutely nothing happens at all. What am I missing here?Also, why does the postgress official documentation guide have such gigantic gaping holes in the information it provides?

Don't forget a semicolon at the end of each SQL command.

user2182349
– user2182349

2017-03-12 23:06:33 +00:00
Commented Mar 12, 2017 at 23:06 — user2182349
– user2182349, Commented Mar 12, 2017 at 23:06
@user2182349 — They haven't written any SQL commands.

Quentin
– Quentin

2017-03-12 23:13:01 +00:00
Commented Mar 12, 2017 at 23:13 — Quentin
– Quentin, Commented Mar 12, 2017 at 23:13

Quentin · Accepted Answer · 2017-03-12 23:07:28Z

1

You appear to have skipped past the part of the documentation that describes the conventions it uses:

SQL commands are preceded by the prompt =>, and shell commands are preceded by the prompt $.

The page you link to says:

$ createdb mydb

So you should run it at the shell prompt and not the postgres prompt. i.e. Don't run the command psql first.

It doesn't tell you to run psql until the next page.

answered Mar 12, 2017 at 23:07

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

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

Collectives™ on Stack Overflow

postgresql create database tutorial

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related