(psql 9.4.5) ERROR: syntax error at or near "createuser"

From: <2athep+5ud7717ssvxx4(at)guerrillamail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: (psql 9.4.5) ERROR: syntax error at or near "createuser"
Date: 2015-11-30 21:32:18
Message-ID: 7366796c7e60b31e8dbf654aba09c38f6030@guerrillamail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Newly installed postgresql 9.4.5

Microsoft Windows 2008 R2 Standard SP1, x64

Installed from postgresql-9.4.5-2-windows-x64.exe

from http://www.enterprisedb.com/products-services-training/pgdownload#windows

File version of psql.exe is p.4.5.15322

I have disabled passwords in pg_hba.conf, because password
is not working for my superuser--this is why I wish to
create a new user--to see if passwords are broken in general,
or only for that first account--so have local method
set to "trust" to get in.

Invoking psql thus:

C:\Program Files\PostgreSQL\9.4\bin>

psql -p 5432 -U postgres

Attempting to create a new user thus:

postgres=# createuser -P -s testuser ;

I get this error:

ERROR: syntax error at or near "createuser"

LINE 1: createuser -P -s testuser ;
^
I do not understand why there is a syntax error at
the keyword createuser.

Can anyone give me any pointers?

- P

----
Sent using GuerrillaMail.com
Block or report abuse: https://www.guerrillamail.com/abuse/?a=UUZnFAFNRLEbjRy1%2FF4PfQfTStiVwcZciatQew%3D%3D

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-11-30 21:38:09 Re: (psql 9.4.5) ERROR: syntax error at or near "createuser"
Previous Message Adrian Klaver 2015-11-30 18:26:35 Re: 2 questions