How to determine the currently logged on username

From: Chris Travers <chris(at)travelamericas(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to determine the currently logged on username
Date: 2003-07-18 13:41:35
Message-ID: 3F17F90F.5020403@travelamericas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Best Wishes,
Chris Travers

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-07-18 14:25:51 Re: How to determine the currently logged on username
Previous Message Richard Huxton 2003-07-18 13:06:00 Re: (trigger function) -> ERROR: NEW used in non-rule query