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