select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Replication and streams

tcn_json

C trigger function that sends primary-key change notifications through LISTEN/NOTIFY.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagetcn_json
Version1.1
RepositoryUnspecified
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars1
Latest commit2017-06-03
Catalogue updated2026-08-30

Related extensions

See also

wal2jsonChanging data capture in JSON format
pgbsonBSON data type and accessor functions for PostgreSQL
decoderbufsLogical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
tablelogTrigger-based audit and change-data-capture extension that records INSERT, UPDATE, and DELETE row images in a central log table and can generate replay SQL.
replisomeLogical-decoding output plugin and Python consumer framework for streaming PostgreSQL row changes as JSON.
jsoncdcJSON logical decoding output plugin
pgmqttCDC-to-MQTT broker for PostgreSQL
wal2mongoPostgreSQL logical decoding output plugin for MongoDB
pgcaptureA scalable Netflix DBLog implementation for PostgreSQL
notify_nowPostgreSQL Extension to send multiple responses from one SQL Query using LISTEN/NOFITY API