Re: PG commands not working?

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

In response to

Browse pgsql-novice by date

  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