For using in production our tdbc::postgres driver, we modified this piece of code
...
" WHERE  schemaname = 'public'"
with this
" WHERE  schemaname = ANY (CURRENT_SCHEMAS(false))"
to have compliance with the search_path of the connection profile.