[Feature request] Support pg_pass

[Guts]

It's quite recommended to store password outside the ~/.pg_service.conf but in a ~/.pgpass file.
It could be really helpful to resolve the password from this complementary file when it does exist.

Relevant docs:

• https://qwat.github.io/docs/fr/installation-guide/workstation.html#database-configuration
• https://www.postgresql.org/docs/current/libpq-envars.html

[3nids]

@Guts we don't have a need to support this at the moment, but any contribution is very welcome :)

[m-kuhn]

Just for making the point, I wouldn't say storing a pw in clear text is ever "recommended". Pgpass support would still be very welcome