CREATE CONVERSION

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

---

NAME

CREATE CONVERSION - å®ä¹ä¸ä¸ªç¨æ·å®ä¹çç å¶è½¬æ¢

SYNOPSIS

CREATE [DEFAULT] CONVERSION name
FOR source_encoding TO dest_encoding FROM funcname

DESCRIPTION æè¿°

CREATE CONVERSION å®ä¹ä¸ç§æ°çç¼ç è½¬æ¢ã 转æ¢çååå¯ä»¥ç¨å¨ convert å½æ°åé¨å£°æç¹å®çç¼ç è½¬æ¢ã åæ ·ï¼æ è®°ä¸º DEFAULT ç转æ¢å¯ä»¥ç¨äºå¨å端åå端ä¹é´çèªå¨ç¼ç è½¬æ¢ã åºäºè¿ä¸ªåå ï¼æ们å¿é¡»å®ä¹ä¸¤ç§è½¬æ¢ï¼ä»ç¼ç  A å° B 以åä»ç¼ç  B å° Aã

为äºå¯ä»¥å建转æ¢ï¼ä½å¿é¡»å¨å½æ°ä¸æEXECUTEæé并ä¸æå¨ç®æ模å¼ä¸çCREATEæéã

PARAMETERS åæ°

DEFAULT

DEFAULT å- å¥è¡¨ç¤ºè¿ç§è½¬æ¢å¯¹äºä»è¿ç§æºç¼çå°ç®çç¼ççæåµæ¯ç¼ºççãå¨ä¸ä¸ªæ¨¡å¼éæ¯ä¸ªç¼ç对åºè¯¥åªæä¸ä¸ªç¼ºçç¼çã

name

转æ¢çåå- ã转æ¢åå¯ä»¥ç¨æ¨¡å¼ä¿®é¥°ãå¦æ没æï¼é£ä¹è½¬æ¢å°±å¨å½å模å¼ä¸- å®ä¹ã转æ¢åå¨ä¸ä¸ªæ¨¡å¼éå¿é¡»å¯ä¸ã

source_encoding

æºç¼ç åã

dest_encoding

ç®çç¼ç åã

funcname

ç¨äºæ§è¡è½¬æ¢çå½æ°ãè¿ä¸ªå½æ°åå¯ä»¥ç¨æ¨¡å¼å修饰ã å¦æ没æï¼é£ä¹å°ä»è·¯å¾ä¸æ¾åºè¿ä¸ªå½æ°ã

æ¤å½æ°å¿é¡»æå¦ä¸çæ ·åï¼

conv_proc(
integer, -- æºç¼ç  ID
integer, -- ç®çç¼ç  ID
cstring, -- æºå串ï¼ç©ºç»å°¾ç C å串ï¼
cstring, -- ç®çå串ï¼ç©ºç»å°¾ç C å串ï¼
integer -- æºå串é¿åº¦
) RETURNS void;

NOTES 注æ

ä½¿ç¨ DROP CONVERSION å é¤ç¨æ·å®ä¹ç转æ¢ã

å建转æ¢æéè¦çæéå¯è½å¨æªæ¥ççæ¬ä¸æ¹åã

EXAMPLES ä¾å

ç¨ myfunc å建ä¸ä¸ªä»ç¼ç  UNICODE å° LATIN1 ç转æ¢ï¼

CREATE CONVERSION myconv FOR ’UNICODE’ TO ’LATIN1’ FROM myfunc;

COMPATIBILITY å¼å®¹æ§

CREATE CONVERSION æ¯ PostgreSQL çæ©å±ã å¨ SQL æ åé没æCREATE CONVERSION è¯å¥ã

SEE ALSO åè§

ALTER CONVERSION [alter_conversion(7)], CREATE FUNCTION [create_function(l)], DROP CONVERSION [drop_conversion(l)]

è¯è

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

è·

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

---