From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
---|---|
To: | Charles Tassell <ctassell(at)isn(dot)net> |
Cc: | Carlos Vicente Altamirano <altacar(at)redes(dot)unam(dot)mx>, pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] users in Postgresql |
Date: | 1999-11-02 09:20:33 |
Message-ID: | Pine.GSO.4.02A.9911021017100.16970-100000@Hermelin.DoCS.UU.SE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1999-11-02 09:53:47 | Re: [GENERAL] Auto Ordering |
Previous Message | User & | 1999-11-02 08:38:37 | why don't this create table work? |
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SEV | 1999-11-02 09:22:40 | Re: [HACKERS] Trigger aborted on error |
Previous Message | Andrzej Mazurkiewicz | 1999-11-02 09:11:43 | inheritance of functions |