Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       CREATE USER -

SYNOPSIS

       CREATE USER name [ [ WITH ] option [ ... ] ]

       where option can be:

             SYSID uid
           | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
           | CREATEDB | NOCREATEDB
           | CREATEUSER | NOCREATEUSER
           | IN GROUP groupname [, ...]
           | VALID UNTIL 'abstime'

DESCRIPTION

       CREATE USER  PostgreSQL    Chapter 17 ``Database Users and Privileges''
       Chapter 19 ``Client Authentication''

PARAMETERS

       name

       uid    SYSID  PostgreSQL

                100

       password
                  ALTER USER [alter_user(7)]

       ENCRYPTED

       UNENCRYPTED
                password_encryption   MD5   ENCRYPTED  UNENCRYPTED /

                MD5

       CREATEDB

       NOCREATEDB
               CREATEDB  NOCREATEDB NOCREATEDB

       CREATEUSER

       NOCREATEUSER
                 NOCREATEUSER

       groupname

       abstime
              VALID UNTIL

NOTES

         ALTER USER [alter_user(7)] DROP  USER  [drop_user(7)]    ALTER  GROUP
       [alter_group(l)]

       PostgreSQL   createuser [createuser(1)] CREATE USER

EXAMPLES

       CREATE USER jonathan;

       CREATE USER davide WITH PASSWORD 'jw8s0F4';

         2004   2005

       CREATE USER miriam WITH PASSWORD 'jw8s0F4' VALID UNTIL '2005-01-01';

       CREATE USER manuel WITH PASSWORD 'jw8s0F4' CREATEDB;

COMPATIBILITY

       CREATE USER  PostgreSQL  SQL

SEE ALSO

       ALTER USER [alter_user(7)], DROP USER [drop_user(l)], createuser(1)

       Postgresql  <laser@pgsqldb.org>