check user in group

From: Philipp Kraus <philipp(dot)kraus(at)flashpixx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: check user in group
Date: 2012-12-25 09:51:06
Message-ID: 8572BC03-761C-45C1-8AA8-F8E3F3CD5C18@flashpixx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

how can I check if a user is within a group? I use current_user() to get the logged-in user, but I have a group "service" and I need a check if the user is member of the group

Thanks

Phil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2012-12-25 10:22:41 Re: check user in group
Previous Message David Johnston 2012-12-25 02:49:28 Re: "?" hstore operator broken in 9.2?