Creating Database Querry in psql CLI

Started by PG Bug reporting form9 months ago3 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/tutorial-createdb.html
Description:

The querry to create database you mentioned in this document (createdb
db_name) is not working in my Debian OS , rather create database db_name;
is working

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: PG Bug reporting form (#1)
Re: Creating Database Querry in psql CLI

On Wed, 2025-07-16 at 03:57 +0000, PG Doc comments form wrote:

Page: https://www.postgresql.org/docs/17/tutorial-createdb.html

The querry to create database you mentioned in this document (createdb
db_name) is not working in my Debian OS , rather create database db_name;
is working

I *guess* (since you say "querry") that you are already on the "psql"
prompt when you enter "createdb db_name", which won't work, since that
is a shell command. The $ at the beginning of the line should give
you that clue.

That would also explain why "create database db_name;" works for you,
because that is an SQL statement.

Yours,
Laurenz Albe

#3David G. Johnston
david.g.johnston@gmail.com
In reply to: PG Bug reporting form (#1)
Re: Creating Database Querry in psql CLI

On Tuesday, July 15, 2025, PG Doc comments form <noreply@postgresql.org>
wrote:

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/tutorial-createdb.html
Description:

The querry to create database you mentioned in this document (createdb
db_name) is not working in my Debian OS , rather create database db_name;
is working

As noted here that $ means you need to be at the OS shell to execute
createdb.

https://www.postgresql.org/docs/17/notation.html

David J.