Dear friends,
I had a look at www.pgsql.ru, looking for how to find out what user is calling the function - from inside the function. No luck.
Could someone enlighten me:
I have a stored function. I want to do the following:
if caller() = ''userA'' then
return -1; -- error
else
return 0;
end if; -- OK
caller() is the function I am looking for. Is there any function like this? If not, is there a way how to write one?
Thanks
Zoltan