Re: How to determine the currently logged on username - Mailing list pgsql-sql

On Friday 18 July 2003 14:41, Chris Travers wrote:
> Hi all;
>
> I will be writing a stored proceedure that will allow a currently logged
> in user to change his/her password.  The function needs to be only able
> to change the password of the currently logged in user, so it will only
> take a varchar() argument and needs to look up the username of the
> currently logged in user.  How do I do this?  Any ideas?

select CURRENT_USER;

--  Richard Huxton Archonet Ltd