PG commands not working?

Поиск
Список
Период
Сортировка
От Just E. Mail
Тема PG commands not working?
Дата
Msg-id 4A1C32F5.6000504@imwell-usa.com
обсуждение исходный текст
Ответы Re: PG commands not working?  (Alan Hodgson <ahodgson@simkin.ca>)
Список 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?

В списке pgsql-novice по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Tool for modeling
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: PG commands not working?