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)