Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       createuser -  PostgreSQL

SYNOPSIS

       createuser [ option... ] [ username ]

DESCRIPTION

       createuser    PostgreSQL  pg_shadow   usesuper   PostgreSQL  createuser
       PostgreSQL

       createuser  SQL  CREATE USER [create_user(7)]

OPTIONS

       createuser

       username
               PostgreSQL   PostgreSQL

       -a

       --adduser
              (: superuser)

       -A

       --no-adduser

       -d

       --createdb

       -D

       --no-createdb

       -e

       --echo
                createuser

       -E

       --encrypted

       -i number

       --sysid number

       -N

       --unencrypted

       -P

       --pwprompt
               createuser

       -q

       --quiet

       createuser

       -h host

       --host host
                 Unix

       -p port

       --port port
                 TCP Unix

       -U username

       --username username

       -W

       --password

ENVIRONMENT

       PGHOST

       PGPORT

       PGUSER

DIAGNOSTICS

         CREATE USER [create_user(7)]  psql(1)    libpq

EXAMPLES

         joe

       $ createuser joe
       Is the new user allowed to create databases? (y/n) n
       Shall the new user be allowed to create more new users? (y/n) n
       CREATE USER

        eden joe 5000

       $ createuser -p 5000 -h eden -D -A -e joe
       CREATE USER "joe" NOCREATEDB NOCREATEUSER
       CREATE USER

SEE ALSO

       dropuser(1), CREATE USER [create_user(7)]

       Postgresql  <laser@pgsqldb.org>