Annotation: office.create_user
CREATE OR REPLACE FUNCTION office.create_user(role_id integer_strict, office_id integer_strict, user_name text, password text, full_name text, elevated boolean DEFAULT false)
RETURNS void
Information: office.create_user
Schema | office |
Function Name | create_user |
Arguments | role_id integer_strict, office_id integer_strict, user_name text, password text, full_name text, elevated boolean DEFAULT false |
Owner | postgres |
Result Type | void |
Description | |
Implementation: office.create_user
CREATE OR REPLACE FUNCTION office.create_user(role_id integer_strict, office_id integer_strict, user_name text, password text, full_name text, elevated boolean DEFAULT false)
RETURNS void
LANGUAGE plpgsql
AS $function$
BEGIN
INSERT INTO office.users(role_id,office_id,user_name,password, full_name, elevated)
SELECT $1, $2, $3, $4,$5, $6;
RETURN;
END
$function$