PSQL - "Data" table decode

ChirpStack (v4) Integrations
1

Hi,

I use psql integration. In my table i’ve “data”. I don’t understand, how my payload is formated, because i’ve this : “\016C\000\000\0015\000\000\205\003>” with a payload “0e490000013a00009602fc”. Can you help me for understand how can i work with this data ? Can i encode to retrun the inital payload ? If yes in what ?

Regards,

2

You could use for example select encode(data, 'hex') as data from XXXX where XXXX. That print the data column as hex.

3

Hi,

It’s work, thanks.