Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get the session user in a C user defined function - Mailing list pgsql-general

From Michael Paquier
Subject Re: How to get the session user in a C user defined function
Date
Msg-id CAB7nPqQdMGbY+WEWp684gpz9pz8YzhBmSoL-+hA=ys4OZwKRmw@mail.gmail.com
Whole thread Raw
In response to How to get the session user in a C user defined function  (John Leiseboer <jleiseboer@bigpond.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: John Leiseboer
Date:
Subject: How to get the session user in a C user defined function
Next
From: Lele Gaifax
Date:
Subject: Re: Understanding "seq scans"