As I was looking for doing similar in embedded cpp via ecpg, here how I to do:
EXEC SQL BEGIN DECLARE SECTION; char * appname = "my_app" ; EXEC SQL END DECLARE SECTION; .... EXEC SQL SET application_name TO :appname ;