HeapTuple to JSON -- composite_to_json()?

Поиск
Список
Период
Сортировка
От Jason Dusek
Тема HeapTuple to JSON -- composite_to_json()?
Дата
Msg-id CAO3NbwPEVOTE-X9LdoipJqfpMOqefdtC8s1_8j8xioiQfnShpQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: HeapTuple to JSON -- composite_to_json()?  (Jason Dusek <jason.dusek@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Yury Zhuravlev
Дата:
Сообщение: Re: Building PostgreSQL 9.6devel sources with MicrosoftVisual C++ 2015?
Следующее
От: Jason Dusek
Дата:
Сообщение: Re: HeapTuple to JSON -- composite_to_json()?