CREATE LANGUAGE

中文man手册

目录

NAME CREATE LANGUAGE
SYNOPSIS .sp .nf CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE
DESCRIPTION 描述
PARAMETERS 参数
NOTES 注意
EXAMPLES 例子
COMPATIBILITY 兼容性
SEE ALSO 参见
译者
跋

CREATE LANGUAGE

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES æ³¨æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·

NAME

CREATE LANGUAGE - å®ä¹ä¸ç§æ°çè¿ç¨è¯è¨

SYNOPSIS

CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE name
HANDLER call_handler [ VALIDATOR valfunction ]

DESCRIPTION æè¿°

ä½¿ç¨ CREATE LANGUAGEï¼ ä¸ä¸ªPostgreSQL ç¨æ·å¯ä»¥å¨ PostgreSQLéæ³¨åä¸ä¸ªæ°çè¯è¨ã å èï¼å½æ°åè§¦åå¨è¿ç¨å¯ä»¥ç¨è¿ç§æ°è¯- è¨å®ä¹ãè¦æ³¨åæ°è¯è¨ç¨æ·å¿é¡»å·æ PostgreSQL è¶çº§ç¨æ·æéã

CREATE LANGUAGE å°è¯¥è¯è¨çåå- åä¸ä¸ªè°ç¨å¥æå³èèµ·æ¥ï¼èè¯¥è°ç¨å¥æè´è´£æ§è¡è¯¥è¯è¨ä¹¦åçå½æ°ã è¯·åè ‘‘User-Defined Functions’’ è·åæå³è¯è¨è°ç¨å¥æçæ´å¤ä¿¡æ¯ã

è¯·æ³¨æè¿ç¨è¯è¨æ¯å¯¹æ¯ä¸ªç¬ç«çæ°æ®åºèè¨æ¯èªå·±çã è¦è®©ä¸ç§è¯- è¨ç¼ºçæ¶å¯ä»¥ä¸ºæææ°æ®åºè·å¾ï¼é£ä½ åºè¯¥æå®å®è£å° template1 æ°æ®åºéã

PARAMETERS åæ°

TRUSTED

TRUSTED è¯´æå¯¹è¯¥è¯è¨çè°ç¨å¥ææ¯å®å¨çï¼ ä¹å°±æ¯è¯´ï¼å®ä¸ä¼æä¾ç»éç¹æç¨æ·ä»»ä½ç»è¿è®¿é®éå¶çè½åã å¦æå¿½ç¥è¿ä¸ªå³é®åï¼åªæå·æ PostgreSQL è¶çº§ç¨æ·æéçäººå¯ä»¥ä½¿ç¨è¿ä¸ªè¯è¨åå»ºæ°çå½æ°ã

PROCEDURAL

è¿æ¯ä¸ªæ²¡æç¨çåã

name

æ°çè¿ç¨åè¯è¨çåç§°ãè¯è¨åæ¯å¤§å°åæ å³çã è¿ä¸ªåå- åºè¯¥å¨æ°æ®åºçææè¯è¨ä¸å¯ä¸ã

åºäºåä¸å¼å®¹çåå ï¼è¿ä¸ªååå¯ä»¥ç¨åå¼å·åå´ã

HANDLER call_handler

call_handler æ¯ä¸ä¸ªä»¥åæ³¨åè¿çå½æ°çåå- ï¼è¯¥å½æ°å°è¢«è°ç¨æ¥æ§è¡è¿é¨è¿ç¨è¯è¨åçå½æ°ã è¿ç¨è¯- è¨çè°ç¨å¥æå¿é¡»ç¨ä¸ç§ç¼è¯è¯è¨ä¹¦åï¼æ¯å¦ Cï¼è°ç¨é£æ ¼å¿é¡»æ¯çæ¬ 1 çè°ç¨é£æ ¼ï¼ å¹¶ä¸å¨ PostgreSQL éæ³¨åä¸ºä¸æ¥ååæ°å¹¶ä¸è¿å language_handler ç±»åçå½æ°ï¼ language_handler æ¯ç¨äºå°å½æ°å£°æä¸ºè°ç¨å¥æçå ä½ç¬¦ã

VALIDATOR valfunction

valfunction æ¯ä¸ä¸ªå·²ç»æ³¨åçå½æ°çååï¼ å¨ç¨è¯¥è¯- è¨åå»ºæ°å½æ°çæ¶åå°è°ç¨å®æ¥æ¡éªæ°å½æ°ãå¦ææ²¡æå£°ææ¡éªå½æ°ï¼é£ä¹å»ºç«æ°å½æ°çæ¶åå°±ä¸ä¼æ£æ¥å®ã æ ¡éªå½æ°å¿é¡»æ¥åä¸ä¸ªç±»åä¸º oid çåæ°ï¼å®æ¯å°è¦åå»ºçå½æ°ç OIDï¼å¹¶ä¸éå¸¸ä¼è¿å voidã

æ ¡éªå½æ°éå¸¸ä¼æ£æ¥å½æ°ä½ï¼çççææ²¡æè¯- æ³éè¯¯ï¼ä½æ¯å®ä¹å¯ä»¥æ¥çå½æ°çå¶å®å±æ§ï¼ æ¯å¦è¯¥è¯- è¨æ¯å¦ä¸è½å¤çæç§åæ°ç±»åãè¦ååºä¸ä¸ªéè¯¯ï¼æ ¡éªå½æ°åºè¯¥ç¨ elog() å½æ°ã è¯¥å½æ°çè¿åå¼å°è¢«å¿½ç¥ã

NOTES æ³¨æ

è¿æ¡å½ä»¤éå¸¸ä¸åºè¯¥ç±ç¨æ·ç´æ¥æ§è¡ã å¯¹äº PostgreSQL çæ¬éæä¾çè¿ç¨è¯- è¨ï¼ æä»¬åºè¯¥ä½¿ç¨ createlang(1) ç¨åºï¼ å®å°ä¸ºæä»¬å®è£æ£ç¡®çè°ç¨å¥æã ï¼createlang ä¹ä¼å¨åé¨è°ç¨ CREATE LANGUAGEãï¼

å¨ PostgreSQL çæ¬ 7.3 ä¹åï¼ æä»¬å¿é¡»å£°æå¥æå½æ°è¿åå ä½ç±»å opaqueï¼èä¸æ¯ language_handlerã ä¸ºäºæ¯æè£è½½æ§çè½¬å¨æä»¶ï¼CREATE LANGUAGE è¿å°æ¥åå£°æä¸ºè¿å opaque çå½æ°ï¼ ä½æ¯å®ä¼ååºä¸æ¡éç¥å¹¶ä¸æå½æ°å£°æè¿åç±»åæ¹ä¸º language_handlerã

ä½¿ç¨ CREATE FUNCTION [create_function(7)] å½ä»¤åå»ºæ°å½æ°ã

ä½¿ç¨ DROP LANGUAGE [drop_language(7)]ï¼æèæ´å¥½æ¯ droplang(1) ç¨åºå é¤ä¸ä¸ªè¿ç¨è¯è¨ã

ç³»ç»è¡¨ pg_language ï¼åé ‘‘System Catalogs’’ï¼ è®°å½äºæ´å¤æå³å½åå®è£çè¿ç¨è¯è¨çä¿¡æ¯ãcreatelang ä¹æä¸ä¸ªéé¡¹ååºå·²å®è£çè¯è¨ã

ç®åï¼é¤äºæéä¹å¤ï¼ä¸ç§è¿ç¨è¯è¨åå»ºä¹åå®çå®ä¹å°±ä¸è½åæ´æ¹ã

è¦ä½¿ç¨ä¸ç§è¿ç¨è¯è¨ï¼ç¨æ·å¿é¡»è¢«èµäº USAGE æéã å¦æè¯¥è¯- è¨å·²ç¥æ¯å¯ä¿¡çï¼é£ä¹ createlang ç¨åºèªå¨ç»æ¯ä¸ªäººèµäºæéã

EXAMPLES ä¾å

ä¸é¢ä¸¤æ¡é¡ºåºæ§è¡çå½ä»¤å°æ³¨åä¸é¨æ°çè¿ç¨è¯è¨åå¶å³èçè°ç¨å¥æã

CREATE FUNCTION plsample_call_handler() RETURNS language_handler
AS ’$libdir/plsample’
LANGUAGE C;
CREATE LANGUAGE plsample
HANDLER plsample_call_handler;

COMPATIBILITY å¼å®¹æ§

CREATE LANGUAGE æ¯ PostgreSQL æ©å±ã

SEE ALSO åè§

ALTER LANGUAGE [alter_language(7)], CREATE FUNCTION [create_function(l)], DROP LANGUAGE [drop_language(l)], GRANT [grant(l)], REVOKE [revoke(l)], createlang(1), droplang(1)

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æåé¡µè®¡åæä¾ã
ä¸æ man æåé¡µè®¡åï¼https://github.com/man-pages-zh/manpages-zh

↑