Alexander Solianic <[EMAIL PROTECTED]> writes:
> Hi, Posgres Gurus!
>
> Does anybody know if there's a way to get name of the current
> session's database in stored procedure, i.e. something like
> CURRENT_USER variable?
what's wrong with current_user?
create function my_user() returns text as '
declare
var_res text;
begin
select current_user into var_res;
return var_res;
end;
' language 'plpgsql';
regression=# select my_func();
my_func
---------
masm
(1 row)
hth,
Manuel.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
