NOTIFY

中文man手册

目录

NAME NOTIFY
SYNOPSIS .sp .nf NOTIFY
DESCRIPTION 描述
PARAMETERS 参数
EXAMPLES 例子
COMPATIBILITY 兼容性
SEE ALSO 参见
译者
跋

NOTIFY

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

NAME

NOTIFY - çæä¸ä¸ªéç¥

SYNOPSIS

NOTIFY name

DESCRIPTION æè¿°

NOTIFY å½ä»¤åå½åæ°æ®åºä¸æææ§è¡è¿ LISTEN nameï¼ æ- £å¨çå¬ç¹å®éç¥æ¡ä»¶çåç«¯åºç¨åéä¸ä¸ªéç¥äºä»¶ã

ä¼ éç»åç«¯çéç¥äºä»¶åæ¬éç¥æ¡ä»¶ååååºéç¥çåç«¯è¿ç¨PIDã æ°æ®åºè®¾è®¡èæè´£ä»»å®ä¹ç¨äºæä¸ªæ°æ®åºçæ¡ä»¶ååæ¯ä¸ªéç¥æ¡ä»¶çå«ä¹ã

éå¸¸ï¼éç¥æ¡ä»¶åä¸æ°æ®åºéçè¡¨çååç¸åï¼ éç¥æ¶é´å®éä¸æå³ç"æä¿®æ¹äºæ- ¤æ°æ®åºï¼è¯·çä¸ç¼æä»ä¹æ°ä¸è¥¿"ã NOTIFY å LISTEN å½ä»¤å¹¶ä¸å¼ºå¶è¿ç§èç³»ãä¾å¦ï¼æ°æ®åºè®¾è®¡èå¯ä»¥ä½¿ç¨åä¸ªä¸åçæ¡ä»¶åæ¥æå¿ä¸ä¸ªè¡¨çåç§ä¸åæ¹åã

NOTIFY ä¸ºè®¿é®åä¸ä¸ª PostgreSQL æ°æ®åºçä¸ç»è¿ç¨æä¾äºä¸ç§ç®åçä¿¡å·å½¢å¼æè¿ç¨é´éè®¯æºå¶ã æ´é«çº§çæºå¶ï¼é¤äºä¸ä¸ªç®åçéç¥åä»¥å¤ï¼å¯ä»¥éè¿ä½¿ç¨æ°æ®åºä¸- çè¡¨ä»éç¥èä¼ éæ°æ®å°è¢«éç¥èã

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

NOTIFY å SQL äºå¡ç¨æç§éè¦çæ¹æ³è¿è¡äº¤æ¢ãé¦åï¼å¦æ NOTIFY å¨äºå¡åé¨æ§è¡ï¼éç¥äºä»¶ç´å°äºå¡æäº¤æä¼éåºã è¿ä¹åæ¯æéççï¼å ä¸ºå¦æäºå¡éåºäºï¼ é£ä¹å¨å®éé¢çææå½ä»¤é½æ²¡æææ ï¼ åæ¬ NOTIFYãä½å¦ææäººå¸æéç¥äºä»¶ç«å³åéï¼è¿å°±ä¸å¤ªå¥½äºã å¶æ¬¡ï¼å½ä¸ä¸ªæ- £å¨çå¬çä¼è¯å¨ä¸æ¬¡äºå¡åæ¶å°ä¸ä¸ªéç¥ä¿¡å·ï¼ ç´å°æ¬æ¬¡äºå¡å®æï¼æäº¤æéåºï¼ä¹åï¼è¯¥éç¥äºä»¶å°ä¸è¢«éå°ä¸ä¹ç¸è¿çå®¢æ·ç«¯ã åæ ·ï¼å¦æä¸ä¸ªéç¥å¨äºå¡åé¨åéåºå»äºï¼ èè¯¥äºå¡ç¨ååéåºäºï¼æä»¬å°±å¸æéç¥å¯ä»¥å¨æç§ç¨åº¦ä¸è¢«æ¤æ¶ï¼ ï¼ä½éç¥ä¸æ¦åéåºå»ï¼æå¡å¨ä¾¿ä¸è½ä»å®¢æ·ç«¯"æ¶å"éç¥ã æä»¥éç¥æ¶é´åªæ¯å¨äºå¡ä¹é´ä¼ éãè¿ä¸ç¹å°±è¦æ±ä½¿ç¨ NOTIFY ä½ä¸ºå®æ¶ä¿¡å·çåºç¨åºè¯¥ç¡®ä¿ä»ä»¬çäºå¡å°½å¯è½çã

NOTIFY å¨ä¸æ¹é¢çè¡ä¸ºè±¡ Unix çä¿¡å·ï¼ å¦æåä¸æ¡ä»¶åå¨ç- æ¶é´åååºäºå¤æ¡ä¿¡å·ï¼æ¥æ¶èå æ¬¡æ§è¡ NOTIFY å¯è½åªåæ¶å°ä¸æ¡éç¥ä¿¡æ¯ã æä»¥ä¾èµäºæ¶å°çéç¥æ¡æ°çæ¹æ³æ¯å¾ä¸å¯é çãå èï¼ä½¿ç¨ NOTIFYå¤ééè¦å³æ³¨æäºçåºç¨ï¼ åæ¶è¿è¦ä½¿ç¨æ°æ®åºå¯¹è±¡ï¼å¦åºåå·ï¼æ¥è·è¸ªäºä»¶åçäºå æ¬¡ã

å®¢æ·ç«¯ç»å¸¸ä¼èªå·±åéä¸æ£å¨çå¬çéç¥åä¸æ ·ç NOTIFYã è¿æ¶å®ï¼å®¢æ·ç«¯ï¼ä¹åå¶ä»æ£å¨çå¬çä¼è¯ä¸æ ·æ¶å°ä¸ä¸ªéç¥äºä»¶ã è¿æ ·å¯è½å¯¼è´ä¸äºæ ç¨çå·¥ä½ï¼ä¸åºç¨é»è¾æå³ï¼ï¼ï¼ ä¾å¦ï¼ å¯¹å®¢æ·ç«¯ååè¿çè¡¨åè¿è¡ä¸æ¬¡è¯»æä½ä»¥åç°æ¯å¦ææ´æ°ã æä»¬å¯ä»¥éè¿æ£æ¥æå¡å¨è¿ç¨çPIDï¼å¨éç¥äºä»¶ä¸æä¾ï¼ æ¯å¦ä¸èªå·±çåç«¯çPIDä¸è´ï¼ä» libpq ä¸åå¾ï¼ãå½ä»ä»¬ä¸æ ·æ¶ï¼ è¯´æè¿æ¯å¶èªèº«åå¼¹çä¿¡æ¯ï¼å¯ä»¥å¿½ç¥ãï¼ä¸ç®¡åé¢ç«èæ¯å¦ä½è®²çï¼è¿æ¯ä¸ä¸ªå®å¨çæå·§ã PostgreSQL ä¿æèªèº«çéç¥åå¶ä»å°æ¥çéç¥åºåå¼ã æä»¥ä½ å±è½äºèªå·±çéç¥åä¸ä¼ç¥è¿å¤é¨çéç¥ãï¼

PARAMETERS åæ°

name

çæä¿¡å·ï¼éç¥ï¼çéç¥æ¡ä»¶ï¼ä»»ä½æ è¯ç¬¦ï¼ã

EXAMPLES ä¾å

å¨ psql ééç½®åæ§è¡ä¸ä¸ªçå¬/éç¥å¯¹ï¼

LISTEN virtual;
NOTIFY virtual;
Asynchronous notification "virtual" received from server process with PID 8448.

COMPATIBILITY å¼å®¹æ§

å¨ SQL æ åéæ²¡æ NOTIFY è¯å¥ã

SEE ALSO åè§

LISTEN [listen(7)], UNLISTEN [unlisten(l)]

è¯è

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

è·

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

↑