This doesn't work, and I've found nothing similar:
ALTER ROLE foo SET SEARCH_PATH = '*';
Is there a single SQL statement which will generate a search path based
on information_schema.schemata, or do I have to write an anonymous DO
procedure?
SELECT schema_name FROM information_schema.schemata WHERE schema_name !=
'information_schema' AND schema_name NOT LIKE 'pg_%';