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

dropuser

劉䓄

dropuser -- 役鍴婔婻䫘潙婊潙

臺濘

dropuser [option...] [username]

柟誄

dropuser 役鍴婔婻 PostgreSQL 䫘潙㔗埻橬轙亓䫘潙启拖橬 CREATEROLE 溄鍊䔇䫘潙埇傖役鍴䫘潙㔗襕役鍴婔婻轙亓䫘潙嘹媙釂饡噽滇轙亓䫘潙㔗

dropuser 滇 SQL 变傴 DROP ROLE 䔇儕輙㔗啹溴䫘巻䓉桹濘役鍴䫘潙鄘婔湙㔗

锬釹

dropuser 毖埖婋彖变傴臯埗昄

username

襕役鍴䔇 PostgreSQL 䫘潙劉㔗套悩嘹澇橬婘变傴臯婪弄滯儖嚔赆柊䴺膷噖婔婻㔗

-e
--echo

啂滆 dropuser 䫘潊幽埏锕䂍橉媇単䔇变傴

-i
--interactive

婘䩘溼役鍴䫘潙嬉柊䴺

-q
--quiet

婉滆䴺巉庫(垬麍昇嚟)

dropuser 誻毖埖婋彖变傴臯埗昄嘩婺誂毖埗昄

-h host
--host host

毺垔誊臯橉媇単䔇婂橺劉㔗套悩昄唚傖桩溹嚔崘彍赆䫘嘩彄 Unix 嘘喖毖庖䔇虇冇㔗

-p port
--port port

毺垔橉媇単溼婘冥劸䔇 TCP 䆇埼潡橸婄 Unix 嘘喖毖庖桺傽䔇欷匘(柟誄严)

-U username
--username username

誕臯誂毖䔇䫘潙劉(婉滇襕役鍴䔇䫘潙劉)

-W
--password

嚺彽埼傴柊䴺(婉滇襕役鍴䔇䫘潙䔇埼傴)

䯇嵄埻麟

PGHOST
PGPORT
PGUSER

䚺䩕誂毖埗昄

自桺

套悩庺䯄髍臇儖嚔滆䴺劯䆇髍臇媇敇㔗埗黙 DROP ROLE 启 psql 诙埡埇脘䔇媇敇柟誄㔗昄扞康橉媇単媙釂婘䕞湺婂橺婪誊臯㔗劯湙傂嘘 libpq 嬉䆇康埇诙冖䔇䚺䩕螆䘞启䯇嵄埻麟鄘儖䫘昽㔗

冋床

役鍴䚺䩕昄扞康橉媇単婪䔇 joe 䫘潙

$ dropuser joe
DROP ROLE

婘婂橺 eden 婪役鍴 joe 䫘潙䆇埼滇 5000 欓臯变傴嬉柊䴺幽婫啂滆欓臯䔇变傴

$ dropuser -p 5000 -h eden -i -e joe
Role "joe" will be permanently removed.
Are you sure? (y/n) y
DROP ROLE "joe"
DROP ROLE

埽蓕

createuser, DROP ROLE, 䯇嵄埻麟(誗29.12)
劯锔饡釕嬉誕
droplang婪婔亓ecpg