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)