File: decoderbufs.sql

package info (click to toggle)
postgres-decoderbufs 3.3.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 188 kB
  • sloc: ansic: 559; makefile: 17; sql: 5; sh: 1
file content (7 lines) | stat: -rw-r--r-- 359 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
 
select slot_name from pg_create_logical_replication_slot('decoderbufs_demo', 'decoderbufs');

create table foo (id int primary key, data text);
insert into foo values (1, 'Important stuff');

select regexp_replace(data, '(txid|commit_time)\[\d+\]', '\1[***]', 'g') as data
from pg_logical_slot_peek_changes('decoderbufs_demo', NULL, NULL, 'debug-mode', '1');