postgresql insert into bytea field

Question

I have procedure:

create or replace function add_task( _g uuid, _name character varying, _ind bytea, _rate integer, _type integer )
returns void as 
$$
begin       
    insert into tasks (g, name, ind, rate, type) values (_g, _name, _ind, _rate, _type);    
end;
$$
language plpgsql;

I need to insert bytea field (_ind). The data is represented as bytes sequence and may be various.

std::vector<uint8_t> data = { 0x01, 0x02, 0x03 };
tr.exec("SELECT add_task_type('" + guid + "', '" + name + "', ......

How I can insert bytea field using SELECT string query?

hruske · Accepted Answer · 2015-12-23 14:19:12Z

3

The most straight forward way would be to use hex format.

SELECT E'\\xDEADBEEF';

See http://www.postgresql.org/docs/9.1/static/datatype-binary.html#AEN5285

answered Dec 23, 2015 at 14:19

hruske

2,24319 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

postgresql insert into bytea field

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