EagleEyes
DTDrizzle Team
•Created by EagleEyes on 9/3/2024 in #help
PostGIS in a separate schema
I have seen it advised to install postgis in a separate schema, not the public schema.
However, I am running into errors such as "error: function st_dwithin(extensions.geometry, unknown, numeric) does not exist" when trying to query using PostGIS functions.
Does Drizzle support extensions installed in schemas other than public?
If so, how do you set the search_path with Drizzle (I understand it's on a session basis)?
5 replies