This question seems so simple but I don't have an answer.
Installed CentOS 5.3, Postgresql 8.3.7 (Libs, Server, Devel) & pgAdmin.
Then created a user/role as follows:
---------------------
% su - postgres
-bash-3.2$creatuser radius --no-superuser --no-createdb --no-createrole -P
Enter password for new role: radius
Enter it again: radius
-bash-3.2$exit
---------------------
Then I checked in pgAdmin & radius is listed under 'login roles'.
Now I tried to create a SCHEMA:
% su - postgres
-bash-3.2$CREATE SCHEMA radius AUTHENCATION radius
Error: create: command not found.
Then tried ';' at the end:
-bash-3.2$CREATE SCHEMA radius AUTHENCATION radius;
Error: create: command not found.
Then I tried the same command as root:
%CREATE SCHEMA radius AUTHENCATION radius
Error: create: command not found.
PostgreSQL manual at page 1029 lists the above command to create a SCHEMA!
------------------------------
What am I doing wrong?