EagleEyes
EagleEyes
PostsComments
DTDrizzle Team
Created by EagleEyes on 9/3/2024 in #help
PostGIS in a separate schema
Thanks @Mario564. I've ended up doing the latter (search_path with the extensions installed in a dedicated schema). I set the search_path in a migration via: 
SET search_path TO "$user", public, extensions;
ALTER database my_db SET search_path TO "$user", public, extensions;
SET search_path TO "$user", public, extensions;
ALTER database my_db SET search_path TO "$user", public, extensions;
The first is to set the search_path for the session (aka running the migrations without having to declare extensions.extension_field and the second is to set the search path permanently. You can't just use the latter as it requires a connection reset to take effect. Seems to be working!
5 replies