On Thu, Oct 15, 2015 at 2:38 PM, John Leiseboer <jleiseboer(at)bigpond(dot)com> wrote:
> I would like to get the session_user into a C char[] in a C language UDF. I have found what appears to be a function returning a Datum type called session_user, but I'm having trouble working out how to call it from within my C function. Can anyone provide some advice on how to do this?
What you are looking for is in miscadmin.h:
username = GetUserNameFromId(GetSessionUserId());
Regards,
--
Michael