postgresql_role search_path with database specification

[joaocc]

Hi,
Currently (1.25.0) the provider allows setting search_path on a ´postgresql_role´, which is a wrapper on

ALTER ROLE xxx db1 SET search_path TO schema_1

This issue is a request to implement a change allowing the setup of something like:

ALTER ROLE xxx IN DATABASE db1 SET search_path TO schema_1

This could be done like adding 'search_path_database' (not perfect, as it only allows one or the other mechanism).
Alternatively, we could allow a search_path_database to receive a dict(string) with the combinations of database+search path.

In our case, we are using search_path in a connection string. However we need to move to pgbounce, which doesn't seem to be compatible with search_path in the connection string (c# driver).

Thanks