search_path wildcard?

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

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