Thread: [DOCS] Incorrect commands in manual for 9.6
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/tutorial-createdb.html Description: In the Postgresql Documentation manual for 9.6.3. I am using windows system and when i execute "CREATEDB MYDB;", i got "ERROR: syntax error at or near "createdb"". And when i execute "CREATE DATABASE MYDB;", it worked fine. Same goes for dropdb command.
On Wednesday, May 24, 2017, <sundeep.sahoo@gmail.com> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/tutorial- createdb.html
Description:
In the Postgresql Documentation manual for 9.6.3. I am using windows system
and when i execute "CREATEDB MYDB;", i got "ERROR: syntax error at or near
"createdb"". And when i execute "CREATE DATABASE MYDB;", it worked fine.
Same goes for dropdb command.
You run "createdb" in your operating system's shell. You run "create database" with psql or some other SQL executing client. From your description you appear to be in an SQL executing program hence createdb and other command line applications will not work.
David J.
Thank you for your help.
On 26-May-2017 11:02 AM, "David G. Johnston" <david.g.johnston@gmail.com> wrote:
On Wednesday, May 24, 2017, <sundeep.sahoo@gmail.com> wrote:The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/tutorial-createdb .html
Description:
In the Postgresql Documentation manual for 9.6.3. I am using windows system
and when i execute "CREATEDB MYDB;", i got "ERROR: syntax error at or near
"createdb"". And when i execute "CREATE DATABASE MYDB;", it worked fine.
Same goes for dropdb command.You run "createdb" in your operating system's shell. You run "create database" with psql or some other SQL executing client. From your description you appear to be in an SQL executing program hence createdb and other command line applications will not work.David J.