Re: Creating Database Querry in psql CLI

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: msd(dot)sheraz046(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Creating Database Querry in psql CLI
Date: 2025-07-17 12:25:58
Message-ID: 9e97b8930ada53c02a538a08db369ab956a5548e.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2025-07-17 12:59:29 Plus sign in column 'Access privileges' of command \dp
Previous Message PG Doc comments form 2025-07-16 03:57:59 Creating Database Querry in psql CLI