pyrox.dev
1init
2{
3 "change": [
4 {
5 "kind": "message",
6 "transactional": false,
7 "prefix": "wal2json",
8 "content": "this non-transactional message will be delivered even if you rollback the transaction"
9 }
10 ]
11}
12{
13 "change": [
14 {
15 "kind": "insert",
16 "schema": "public",
17 "table": "table2_with_pk",
18 "columnnames": ["a", "b", "c"],
19 "columntypes": ["integer", "character varying(30)", "timestamp without time zone"],
20 "columnvalues": [1, "Backup and Restore", "2018-03-27 12:05:29.914496"]
21 }
22 ,{
23 "kind": "insert",
24 "schema": "public",
25 "table": "table2_with_pk",
26 "columnnames": ["a", "b", "c"],
27 "columntypes": ["integer", "character varying(30)", "timestamp without time zone"],
28 "columnvalues": [2, "Tuning", "2018-03-27 12:05:29.914496"]
29 }
30 ,{
31 "kind": "insert",
32 "schema": "public",
33 "table": "table2_with_pk",
34 "columnnames": ["a", "b", "c"],
35 "columntypes": ["integer", "character varying(30)", "timestamp without time zone"],
36 "columnvalues": [3, "Replication", "2018-03-27 12:05:29.914496"]
37 }
38 ,{
39 "kind": "message",
40 "transactional": true,
41 "prefix": "wal2json",
42 "content": "this message will be delivered"
43 }
44 ,{
45 "kind": "delete",
46 "schema": "public",
47 "table": "table2_with_pk",
48 "oldkeys": {
49 "keynames": ["a", "c"],
50 "keytypes": ["integer", "timestamp without time zone"],
51 "keyvalues": [1, "2018-03-27 12:05:29.914496"]
52 }
53 }
54 ,{
55 "kind": "delete",
56 "schema": "public",
57 "table": "table2_with_pk",
58 "oldkeys": {
59 "keynames": ["a", "c"],
60 "keytypes": ["integer", "timestamp without time zone"],
61 "keyvalues": [2, "2018-03-27 12:05:29.914496"]
62 }
63 }
64 ,{
65 "kind": "insert",
66 "schema": "public",
67 "table": "table2_without_pk",
68 "columnnames": ["a", "b", "c"],
69 "columntypes": ["integer", "numeric(5,2)", "text"],
70 "columnvalues": [1, 2.34, "Tapir"]
71 }
72 ]
73}
74stop