1. Brent Tubbs
  2. decoder_json
  3. Issues
Issue #1 new

Double quotes around column named "time"

Brent Tubbs
repo owner created an issue
postgres=# \d points_transactions
                                  Table "public.points_transactions"
 Column  |           Type           |                            Modifiers                             
---------+--------------------------+------------------------------------------------------------------
 id      | integer                  | not null default nextval('points_transactions_id_seq'::regclass)
 user_id | integer                  | 
 amount  | integer                  | 
 time    | timestamp with time zone | default now()
Indexes:
    "points_transactions_pkey" PRIMARY KEY, btree (id)

postgres=# insert into points_^C
postgres=# INSERT INTO points_transactions (user_id, amount) VALUES (12345, 500);
INSERT 0 1
postgres=# INSERT INTO points_transactions (user_id, amount) VALUES (54321, -100);
INSERT 0 1
vagrant@vagrant-ubuntu-trusty-64:~$ pg_recvlogical --slot=test_decoder_json_streaming --dbname=postgres --user=postgres --start -f -
^[{"table":"public.points_transactions","op":"INSERT","data":{"id":1,"user_id":12345,"amount":500,""time"":"2015-01-14T07:23:25.649838+00:00"}}
{"table":"public.points_transactions","op":"INSERT","data":{"id":2,"user_id":54321,"amount":-100,""time"":"2015-01-14T07:23:41.097829+00:00"}}

Comments (0)

  1. Log in to comment