Обсуждение: How to get the session user in a C user defined function

Поиск
Список
Период
Сортировка

How to get the session user in a C user defined function

От
John Leiseboer
Дата:
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
returninga Datum type called session_user, but I'm having trouble working out how to call it from within my C function.
Cananyone provide some advice on how to do this? 

John
Email: jleiseboer@bigpond.com

Re: How to get the session user in a C user defined function

От
Michael Paquier
Дата:
On Thu, Oct 15, 2015 at 2:38 PM, John Leiseboer <jleiseboer@bigpond.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
returninga Datum type called session_user, but I'm having trouble working out how to call it from within my C function.
Cananyone provide some advice on how to do this? 

What you are looking for is in miscadmin.h:
username = GetUserNameFromId(GetSessionUserId());
Regards,
--
Michael