PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

CREATE USER

劉䓄

CREATE USER -- 垔幬婔婻桄昄扞康蓐謾

臺濘

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

認麯 option 埇傖滇
    
      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | CREATEUSER | NOCREATEUSER
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | CONNECTION LIMIT connlimit
    | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
    | VALID UNTIL 'timestamp' 
    | IN ROLE rolename [, ...]
    | IN GROUP rolename [, ...]
    | ROLE rolename [, ...]
    | ADMIN rolename [, ...]
    | USER rolename [, ...]
    | SYSID uid

柟誄

CREATE USER 䯄婘滇 CREATE ROLE 䔇彆劉埗黙劯蔙傖诙埡敘崔媇敇㔗嫇婔䔇寺彆滇 CREATE USER 变傴䚺䩕啺螆橬 LOGIN 蔯 CREATE ROLE 䚺䩕滇 NOLOGIN 㔗

噚垹攓

CREATE USER 臺埖滇 PostgreSQL 欷匘㔗SQL 湺庖檪䫘潙䔇垔幬庴䂍庖垂䯄準垯潊㔗

埽蓕

CREATE ROLE
劯锔饡釕嬉誕
CREATE TYPE婪婔亓CREATE VIEW