Make session (pool) use a specified schema

The goal is to have queries/commands target a specified schema instead of the default "public"

As @tpolecat suggested this is achieved by setting the search_path session connection parameter.

And indeed it works. This is a battle tested example:

    import skunk._
    implicit val noopTrace: Trace[F] = Trace.Implicits.noop[F]
    
    Session.pooled(
        parameters = Map("search_path", "my_schema") ++ Session.DefaultConnectionParameters,
        host       = ???,
        port       = ???,
        user       = ???,
        database   = ???,
        password   = ???
      )

Furthermore, by looking at the postgresql docs the search_path is a a complex beast, and there's many more ways to use it.

So it's up for disscussion what the best API would be to easily allow doing the above with minimal footgunning risk.

At the very least this issue helps people find the way to solve the same problem.

Start with the Session.pooled entry point and its parameters, including Session.DefaultConnectionParameters. Read the PostgreSQL search_path documentation and compare the existing parameter approach with the API options discussed in the issue. Done means there is a decided, safe API for targeting a specified schema without unnecessary footguns.