how to use the bytea type of postgres in c language.
please give me a example.

i did it like this ,but it didn't work

...
FILE *file;
char ch[3000];

file=fopen("pic.jpg","r");
memset(cr.0,sizeof(cr);
fgets(cr,2999,file);
...
exec sql insert into table_test(1,:cr); //table_test(id numeric,file bytea)