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

droplang

劉䓄

droplang -- 役鍴婔婻誺䘋臺蘔

臺濘

droplang [connection-option...] langname [dbname]
droplang [connection-option...] --list | -l dbname

柟誄

droplang 滇婔婻傯昄扞康婺役鍴婔䓉䯄橬䚡䘋臺蘔䔇噖噙㔗droplang 埇傖役鍴傂嘘誺䘋臺蘔䫔躿滇闼底 PostgreSQL 䬽橸澇橬躻婥䔇㔗

儘䞇埇傖䫘 SQL 变傴䕘毖役鍴劯䆇䚡䘋臺蘔嘖誻滇毘艊嘪䫘 droplang 啹婺垄誕臯庖婔底演昖蔯婫敘垹滷嘪䫘㔗埗黙 DROP LANGUAGE 诙埡敘崔媇敇㔗

锬釹

droplang 毖埖婋麵䔇变傴臯埗昄

langname

剿儖赆役鍴䔇劯䆇䚡䘋臺蘔䔇劉䓄

[-d] dbname
[--dbname] dbname

毺垔傯巻婻昄扞康役鍴臖臺蘔㔗䚺䩕嘪䫘启嘷嬉係䂘䫘潙劯劉䔇昄扞康㔗

-e
--echo

啂滆欓臯䔇 SQL 变傴

-l
--list

滆䴺婔婻婘䕞湺昄扞康麯噾䂟垬輙䔇臺蘔䔇彖臘

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

-h host
--host host

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

-p port
--port port

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

-U username
--username username

誂毖䔇䫘潙劉

-W
--password

嚺彽埼傴柊䴺

䯇嵄埻麟

PGDATABASE
PGHOST
PGPORT
PGUSER

䚺䩕誂毖埗昄

自桺

崔昄髍臇媇敇鄘滇躻蓼麪䔇㔗套悩婉滇嘪䫘 --echo 锬釹誊臯 droplang 䇽劯鐽凹䕩庫䔇 SQL 变傴演昖䂖誗㔗

濘懟

嘪䫘 createlang 嵂媹婔䓉臺蘔㔗

冋床

役鍴 pltcl 臺蘔

$ droplang pltcl dbname

埽蓕

createlang, DROP LANGUAGE, 䯇嵄埻麟(誗29.12)
劯锔饡釕嬉誕
dropdb婪婔亓dropuser