How to insert/update [Binary][1] value into DB column in Postgres

Question

I have a binary that look like this

CRN=$\x00\x00\x00\x06\x03 \x00\x00\x00\x01

I want it to be saved in DB like this

update table set column='CRN=$\x00\x00\x00\x06\x03 \x00\x00\x00\x01';

But apparently I think the above is not correct what should I do to insert the following in DB.

Brian Nguyen · Accepted Answer · 2017-12-11 21:49:49Z

1

According to the Postgresql docs, you will need to use one of two possible escape sequences.

Both start with E'\. If you use the hex option, you append \x followed by your data in hex representation. Or you could use the ASCII-friendly format where you only have to escape the octets for the non-printable characters by outputting the octal values, e.g. \000. This is assuming you have a bytea column to store the binary data.

Your data seems to be a mixture of raw binary data and printable characters like CRN=$ so it's really up to you.

answered Dec 11, 2017 at 21:49

Brian Nguyen

6814 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

How to insert/update [Binary][1] value into DB column in Postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related