HeapTuple to JSON -- composite_to_json()? - Mailing list pgsql-general

From Jason Dusek
Subject HeapTuple to JSON -- composite_to_json()?
Date
Msg-id CAO3NbwPEVOTE-X9LdoipJqfpMOqefdtC8s1_8j8xioiQfnShpQ@mail.gmail.com
Whole thread Raw
Responses Re: HeapTuple to JSON -- composite_to_json()?
List pgsql-general

Hi All,

I am working on a logical decoder and would like to convert a heap tuple to JSON (a HeapTuple obtained from ReorderBufferChange). It is the moral equivalent of tuple_to_stringinfo in test_decode.c:

http://doxygen.postgresql.org/test__decoding_8c.html#a3986a57a0308de0150ebd45f7734d464

It seems like the easiest and best thing to do is to rely on Postgres’s native JSON serialization. A HeapTuple is not a Datum; but reading heaptuple.c they seem to have a close relationship. Do arrays of Datum become HeapTuple? Is a HeapTuple basically Datum sans type information? What is the best way to convert a HeapTuple to a Datum?

Best Regards,

  Jason Dusek

pgsql-general by date:

Previous
From: Yury Zhuravlev
Date:
Subject: Re: Building PostgreSQL 9.6devel sources with MicrosoftVisual C++ 2015?
Next
From: Jason Dusek
Date:
Subject: Re: HeapTuple to JSON -- composite_to_json()?