> Somehow we are going to need to get the schema defined in
> pg_service.conf out of libpg. I have no clue how to do that. Figuring
> out what db is used is a major hack.

> Gotcha. As I mentioned above I have no idea how to get the schema from
> here.

I've never worked with psycopg directly, I've only used it as a
dependency for web applications.

Can we get the connection parameters if it was not established
successfully? If so, we can try to connect and store the values in a
variable. Psycopg must return all connection values, including implicit
ones.

https://www.psycopg.org/docs/connection.html#connection.get_dsn_parameters

This is just a guess, but it might be worth a try.