db/rest/util/_api_get_user_id.sql


1
2
3
4
5
6
7
8
9
10
11

CREATE FUNCTION _api.get_user_id()
RETURNS INTEGER
LANGUAGE plpgsql VOLATILE
AS $BODY$
BEGIN
	RETURN CURRENT_SETTING(
		'request.jwt.claims',
		TRUE
	)::JSON->>'user_id';
END
$BODY$;