Set search path for Postgres in a Rails app I have a project in heroku. I have the URI that enables me to connect with the database in my external rails app. How do I change or set the search path in ruby code?
You can define it in your database.yml using the schema_search_path key with a string value

production:
  adapter: postgresql
  ...
  schema_search_path: 'schema1,public'


You can find out a bit more here: https://til.hashrocket.com/posts/5aa2892b43-set-schema-search-path