From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: PG commands not working? |
Date: | 2009-05-28 11:52:55 |
Message-ID: | gvltun$23o$1@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 2009-05-26, Just E. Mail <justemail(at)imwell-usa(dot)com> wrote:
> 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'.
that bit worked.
> Now I tried to create a SCHEMA:
>
> % su - postgres
>
> -bash-3.2$CREATE SCHEMA radius AUTHENCATION radius
> Error: create: command not found.
here you need to do psql to get the postgres command-line
the prompt will look like this
postgres=#
before creating a schema you probably want to create (or if it already
exists connect to) a different database,
postgres=# create database radius owner radius;
CREATE DATABASE
postgres=# \c radius
radius=# CREATE SCHEMA radius AUTHENCATION radius;
CREATE SCHEMA
From | Date | Subject | |
---|---|---|---|
Next Message | Jasen Betts | 2009-05-28 12:03:03 | Re: Postgres registry access using java |
Previous Message | Albe Laurenz | 2009-05-28 11:09:25 | Re: Postgres registry access using java |