From: | "Just E(dot) Mail" <justemail(at)imwell-usa(dot)com> |
---|---|
To: | PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | PG commands not working? |
Date: | 2009-05-26 18:20:37 |
Message-ID: | 4A1C32F5.6000504@imwell-usa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Alan Hodgson | 2009-05-26 18:33:29 | Re: PG commands not working? |
Previous Message | Thomas Kellerer | 2009-05-26 16:03:56 | Re: Tool for modeling |