Help C prog and sql varchar column

Hello,

Excuse me for disturbing but do you have any examples of program C for
psql linux with a sql cursor in it selecting a varchar column in a sql
table?

All examples (1,2,3)  in the manual deal with numeric column.

Thank you in advance.

Patrick.