Re: [GENERAL] users in Postgresql

The "SQL" command (it isn't really part of the standard) is CREATE USER.
The bin/createuser is a script that calls psql and issues a create user
command. (Another confused user on the ever-growing list. How can we make
this clearer?)

Btw., although direct UPDATEs to pg_shadow will seemingly succeed, you do
not want to do that. That's a bug.

    -Peter

On Mon, 1 Nov 1999, Charles Tassell wrote:

> Use the command createuser in your pgsql/bin directory.   Not sure how to
> do it in SQL, maybe alter user or create user?
>
> At 05:41 PM 11/1/99, Carlos Vicente Altamirano wrote:
>
> >How can i add a user (root for example) in pg_shadow?
> >
> >Atte.
> >
> >=======================================
> >Carlos A. Vicente Altamirano
> >Centro de Asistencia Tecnica de RedUNAM
> >Depto. de Operacion de la Red
> >DGSCA-UNAM
> >Tel. 6228526-28
> >=======================================
> >
> >
> >
> >************
>
>
> ************
>
>

--
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden