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_%';