ALTER ROLE fiona SET search_path = finance;

ALTER DATABASE name_of _database SET search_path = public, postgis;

ALTER ROLE fiona SET search_path = public, postgis, finance;

ALTER DATABASE your_db SET search_path = "$user", postgis, public;

ALTER EXTENSION postgis set schema postgis; --will fail :(

CREATE EXTENSION postgis SCHEMA whereever_I_damn_want_you_to_be;