PG commands not working?

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?

Responses

Browse pgsql-novice by date

  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