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