Insert bytea into postgresql json type

Question

I am trying with no success to insert a byte array in a postgresql json type as one of the json columns. is it possible? does anyone have an example?

Why would you want to insert bytes instead of text in such a column? Can you post the code you're using (esp. the part that fails)? — mabi
– mabi, Commented Dec 5, 2013 at 13:53

Chris Travers · Accepted Answer · 2013-12-22 07:23:09Z

1

You can't, at least natively. JSON only allows 3 basic primative data types: number, string, and boolean. Everything else must be serialized to a string or number.

This means that you have three basic options:

Serialize to hexadecimal. The advantage is that it becomes easy to turn into a bytea in PostgreSQL if you need it.
Serialize to base64. The advantage here is that it uses up less space.
Serialize to a number array. This is not preferred in my view since it is hard to constrain each number to between 0 and 255.

answered Dec 22, 2013 at 7:23

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zeeshan Shamsuddeen Over a year ago

when you say JSON allows 3 data types, are you referring to the values in a JSON object?

Collectives™ on Stack Overflow

Insert bytea into postgresql json type

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related