is_member.md

description
Returns whether the current user is a member of the specified role.

IS_MEMBER

Syntax

IS_MEMBER(expression varchar) → boolean

• expression: String expression identifying a role in Spice.

Examples

{% code title="IS_MEMBER example" %}

SELECT IS_MEMBER ('public')
-- True

{% endcode %}

{% code title="IS_MEMBER example" %}

SELECT IS_MEMBER ('non-role')
-- False

{% endcode %}