{"Entry":{"collection":"func","key":"pg-logical-emit-message","name":"pg_logical_emit_message","aliases":[],"metadata":{"changed_in":["17"],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"9.5","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"9.6"},{"descriptions_changed":false,"doc_overhaul":true,"from":"12","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"13"},{"descriptions_changed":true,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":["pg_logical_emit_message ( transactional boolean, prefix text, content text [, flush boolean DEFAULT false] ) → pg_lsn","pg_logical_emit_message ( transactional boolean, prefix text, content bytea [, flush boolean DEFAULT false] ) → pg_lsn"],"removed":["pg_logical_emit_message ( transactional boolean, prefix text, content text ) → pg_lsn","pg_logical_emit_message ( transactional boolean, prefix text, content bytea ) → pg_lsn"]},"status":"changed","to":"17"}],"content_hash":"4388e0e799e0573650541a341ae7454cb1baa28c88f74e66b40aae64e30ee6ec","first_version":"9.6","group":"admin","group_label":"System Administration Functions","groups":["admin"],"imported_at":"2026-09-27T17:57:29.554523+08:00","last_version":"20","name":"pg_logical_emit_message","name_key":"pg_logical_emit_message","position":29056,"present_in":["9.6","10","11","12","13","14","15","16","17","18","19","20"],"signature":"pg_logical_emit_message ( transactional boolean, prefix text, content text [, flush boolean DEFAULT false] ) → pg_lsn","signature_count":2,"slug":"pg-logical-emit-message","source_rev":"b7bd9cda","summary":"Emits a logical decoding message.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-logical-emit-message","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-logical-emit-message","SourceRevision":"b7bd9cda","Facts":{"description":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The transactional parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The prefix parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The content parameter is the content of the message, given either in text or binary form. The flush parameter (default set to false) controls if the message is immediately flushed to WAL or not. flush has no effect with transactional, as the message's WAL record is flushed along with its transaction.","description_html":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e parameter is the content of the message, given either in text or binary form. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e parameter (default set to \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e) controls if the message is immediately flushed to WAL or not. \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e has no effect with \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e, as the message's WAL record is flushed along with its transaction.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-REPLICATION-TABLE","file":"functions-admin.html","slug":"18"},"group":"admin","group_label":"System Administration Functions","lang":"en","layout":"table-new","pages":["functions-admin.html"],"prose_only":false,"signatures":[{"description":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The transactional parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The prefix parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The content parameter is the content of the message, given either in text or binary form. The flush parameter (default set to false) controls if the message is immediately flushed to WAL or not. flush has no effect with transactional, as the message's WAL record is flushed along with its transaction.","description_html":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e parameter is the content of the message, given either in text or binary form. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e parameter (default set to \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e) controls if the message is immediately flushed to WAL or not. \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e has no effect with \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e, as the message's WAL record is flushed along with its transaction.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_logical_emit_message\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_logical_emit_message ( transactional boolean, prefix text, content text [, flush boolean DEFAULT false] ) → pg_lsn","zh_from":""},{"description":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The transactional parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The prefix parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The content parameter is the content of the message, given either in text or binary form. The flush parameter (default set to false) controls if the message is immediately flushed to WAL or not. flush has no effect with transactional, as the message's WAL record is flushed along with its transaction.","description_html":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e parameter is the content of the message, given either in text or binary form. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e parameter (default set to \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e) controls if the message is immediately flushed to WAL or not. \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e has no effect with \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e, as the message's WAL record is flushed along with its transaction.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_logical_emit_message\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebytea\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_logical_emit_message ( transactional boolean, prefix text, content bytea [, flush boolean DEFAULT false] ) → pg_lsn","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-REPLICATION-TABLE","file":"functions-admin.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-logical-emit-message","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_logical_emit_message","Summary":"发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。transactional 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。prefix 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。content 参数是消息内容，可以文本或二进制形式给出。flush 参数（默认为 false）控制是否立即将消息对应的 WAL 记录刷盘。transactional 为真时，flush 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。","BodyHTML":"发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。\u003cem\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。\u003cem\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。\u003cem\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e 参数是消息内容，可以文本或二进制形式给出。\u003cem\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 参数（默认为 \u003ccode\u003efalse\u003c/code\u003e）控制是否立即将消息对应的 WAL 记录刷盘。\u003cem\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 为真时，\u003cem\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。\u003cpre\u003epg_logical_emit_message ( transactional boolean, prefix text, content text [, flush boolean DEFAULT false] ) → pg_lsn\u003c/pre\u003e发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。\u003cem\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。\u003cem\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。\u003cem\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e 参数是消息内容，可以文本或二进制形式给出。\u003cem\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 参数（默认为 \u003ccode\u003efalse\u003c/code\u003e）控制是否立即将消息对应的 WAL 记录刷盘。\u003cem\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 为真时，\u003cem\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。\u003cpre\u003epg_logical_emit_message ( transactional boolean, prefix text, content bytea [, flush boolean DEFAULT false] ) → pg_lsn\u003c/pre\u003e发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。\u003cem\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。\u003cem\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。\u003cem\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e 参数是消息内容，可以文本或二进制形式给出。\u003cem\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 参数（默认为 \u003ccode\u003efalse\u003c/code\u003e）控制是否立即将消息对应的 WAL 记录刷盘。\u003cem\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 为真时，\u003cem\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。","SourceRevision":"ca936764","ContentHash":"6b54fd9d239d9c691a6facad58ef04c70cedb23dfd1b06977717380d287462da","Payload":{"description_zh":"发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。transactional 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。prefix 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。content 参数是消息内容，可以文本或二进制形式给出。flush 参数（默认为 false）控制是否立即将消息对应的 WAL 记录刷盘。transactional 为真时，flush 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。","description_zh_html":"发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。\u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。\u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。\u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e 参数是消息内容，可以文本或二进制形式给出。\u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 参数（默认为 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e）控制是否立即将消息对应的 WAL 记录刷盘。\u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 为真时，\u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。","signatures":[{"description_zh":"发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。transactional 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。prefix 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。content 参数是消息内容，可以文本或二进制形式给出。flush 参数（默认为 false）控制是否立即将消息对应的 WAL 记录刷盘。transactional 为真时，flush 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。","description_zh_html":"发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。\u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。\u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。\u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e 参数是消息内容，可以文本或二进制形式给出。\u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 参数（默认为 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e）控制是否立即将消息对应的 WAL 记录刷盘。\u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 为真时，\u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。","returns":"pg_lsn","text":"pg_logical_emit_message ( transactional boolean, prefix text, content text [, flush boolean DEFAULT false] ) → pg_lsn","zh_from":"doc"},{"description_zh":"发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。transactional 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。prefix 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。content 参数是消息内容，可以文本或二进制形式给出。flush 参数（默认为 false）控制是否立即将消息对应的 WAL 记录刷盘。transactional 为真时，flush 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。","description_zh_html":"发出逻辑解码消息。这可用于通过 WAL 向逻辑解码插件传递通用消息。\u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 参数指定消息是作为当前事务的一部分，还是立即写入并在逻辑解码器读到该记录时立即解码。\u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e 参数是一个文本前缀，便于逻辑解码插件识别其关注的消息。\u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e 参数是消息内容，可以文本或二进制形式给出。\u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 参数（默认为 \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e）控制是否立即将消息对应的 WAL 记录刷盘。\u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e 为真时，\u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e 不起作用，因为消息的 WAL 记录会与其事务一起刷盘。","returns":"pg_lsn","text":"pg_logical_emit_message ( transactional boolean, prefix text, content bytea [, flush boolean DEFAULT false] ) → pg_lsn","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","9.6"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"4903d2680b5403bb987296476ff71e88d9e6db8543afbcc59f66cb8dff18a57c","Text":"pg_logical_emit_message ( transactional boolean, prefix text, content text [, flush boolean DEFAULT false] ) → pg_lsn","Returns":"pg_lsn","Payload":{"description":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The transactional parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The prefix parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The content parameter is the content of the message, given either in text or binary form. The flush parameter (default set to false) controls if the message is immediately flushed to WAL or not. flush has no effect with transactional, as the message's WAL record is flushed along with its transaction.","description_html":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e parameter is the content of the message, given either in text or binary form. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e parameter (default set to \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e) controls if the message is immediately flushed to WAL or not. \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e has no effect with \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e, as the message's WAL record is flushed along with its transaction.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_logical_emit_message\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_logical_emit_message ( transactional boolean, prefix text, content text [, flush boolean DEFAULT false] ) → pg_lsn","zh_from":""}},{"Version":"18","Ordinal":1,"Hash":"83774c9c45b48c85899f38ae4e0266fc493eb1e2f179f80c21e3c497162dd8ab","Text":"pg_logical_emit_message ( transactional boolean, prefix text, content bytea [, flush boolean DEFAULT false] ) → pg_lsn","Returns":"pg_lsn","Payload":{"description":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The transactional parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The prefix parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The content parameter is the content of the message, given either in text or binary form. The flush parameter (default set to false) controls if the message is immediately flushed to WAL or not. flush has no effect with transactional, as the message's WAL record is flushed along with its transaction.","description_html":"Emits a logical decoding message. This can be used to pass generic messages to logical decoding plugins through WAL. The \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e parameter specifies if the message should be part of the current transaction, or if it should be written immediately and decoded as soon as the logical decoder reads the record. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e parameter is a textual prefix that can be used by logical decoding plugins to easily recognize messages that are interesting for them. The \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e parameter is the content of the message, given either in text or binary form. The \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e parameter (default set to \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e) controls if the message is immediately flushed to WAL or not. \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e has no effect with \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e, as the message's WAL record is flushed along with its transaction.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_logical_emit_message\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etransactional\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eprefix\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003econtent\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebytea\u003c/code\u003e [\u003cspan class=\"optional\"\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eflush\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e \u003ccode class=\"literal\"\u003eDEFAULT\u003c/code\u003e \u003ccode class=\"literal\"\u003efalse\u003c/code\u003e\u003c/span\u003e] ) → \u003ccode class=\"returnvalue\"\u003epg_lsn\u003c/code\u003e","returns":"pg_lsn","text":"pg_logical_emit_message ( transactional boolean, prefix text, content bytea [, flush boolean DEFAULT false] ) → pg_lsn","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}