" WHERE usename LIKE '%s'"

#defineQuery_for_list_of_user_vars \

" SELECT pg_catalog.split_part(pg_catalog.unnest(rolconfig),'=',1) "\

" FROM pg_catalog.pg_roles "\

" WHERE rolname LIKE '%s'"

"SELECT conf FROM ("\

" SELECT rolname, pg_catalog.split_part(pg_catalog.unnest(rolconfig),'=',1) conf"\

" FROM pg_catalog.pg_roles"\

" ) s"\

" WHERE s.conf like '%s' "\

" AND s.rolname LIKE '%s'"

#defineQuery_for_list_of_access_methods \

" SELECT amname "\

elseif (Matches("ALTER","USER|ROLE",MatchAny,"RESET"))

{

set_completion_reference(prev2_wd);

COMPLETE_WITH_QUERY_PLUS(Query_for_list_of_user_vars,"ALL");

}

elseif (Matches("ALTER","USER|ROLE",MatchAny,"WITH"))

elseif (TailMatches("SET|RESET")&&

!TailMatches("UPDATE",MatchAny,"SET")&&

!TailMatches("ALTER","DATABASE",MatchAny,"RESET"))

!TailMatches("ALTER","DATABASE|USER|ROLE",MatchAny,"RESET"))

COMPLETE_WITH_QUERY_VERBATIM_PLUS(Query_for_list_of_set_vars,

"CONSTRAINTS",

"TRANSACTION",