LISTEN

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

---

NAME

LISTEN - çå¬ä¸ä¸ªéç¥

SYNOPSIS

LISTEN name

DESCRIPTION æè¿°

LISTEN å°å½åä¼è¯æ³¨å为éç¥æ¡ä»¶ name

å½æ§è¡äºå½ä»¤ NOTIFY name åï¼ä¸ç®¡æ¯æ- ¤ä¼è¯è¿æ¯å¶ä»èæ¥å°åä¸æ°æ®åºçä¼è¯æ§è¡çï¼ æææ£å¨çå¬æ- ¤éç¥æ¡ä»¶çä¼è¯é½å°æ¶å°éç¥ï¼ 并ä¸æ¥ä¸æ¥æ¯ä¸ªä¼è¯å°éç¥ä¸å¶ç¸è¿çå端åºç¨ï¼è¯·åè NOTIFY è·åæ´å¤ä¿¡æ¯ï¼

ä½¿ç¨ UNLISTEN å½ä»¤ï¼å¯ä»¥å°ä¸ä¸ªä¼è¯å已注åçéç¥æ¡ä»¶å é¤ï¼ åæ ·ï¼ä¼è¯éåºæ¶èªå¨å é¤è¯¥ä¼è¯æ£å¨çå¬ç已注åéç¥æ¡ä»¶ï¼

å端åºç¨æ£æµéç¥äºä»¶çæ¹æ³åå³äº PostgreSQL åºç¨ä½¿ç¨çç¼ç¨æ¥å£ï¼ å¦æ使ç¨åºæ¬çlibpqåºï¼ åºç¨å° LISTEN å½ä½æ®é SQL å½ä»¤ä½¿ç¨ï¼èä¸å¿é¡»å¨æå°è°ç¨ PQnotifies è¿ç¨æ¥æ£æµæ¯å¦æéç¥å°è¾¾ï¼ å¶ä»ålibpgtclæ¥å£æä¾äºæ´é«çº§çæ§å¶éç¥äºä»¶çæ¹æ³ï¼å®éä¸ï¼ 使ç¨libpgtclï¼åºç¨ç¨åºåä¸åºè¯¥ç´æ¥ä½¿ç¨ LISTEN æ UNLISTENï¼ è¯·åè你使ç¨çæ¥å£çææ¡£è·åæ´å¤ç»èï¼

NOTIFY [notify(7)] çæå页åå«æ´å¹¿æ³çå³äº LISTEN å NOTIFY ç使ç¨ç讨论ï¼

PARAMETERS åæ°

name

éç¥æ¡ä»¶å (ä»»ä½æ è¯ç¬¦)ã

EXAMPLES ä¾å

å¨ psql ééå¶åæ§è¡ä¸ä¸ªçå¬/éç¥åºåï¼

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

COMPATIBILITY å¼å®¹æ§

å¨ SQL æ åé没æ LISTEN

SEE ALSO åè§

NOTIFY [notify(7)], UNLISTEN [unlisten(l)]

è¯è

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

è·

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

---