PGSERVICEFILE as part of a normal connection string

Torsten Förtsch <tfoertsch123@gmail.com>

From: Torsten Förtsch <tfoertsch123@gmail.com>

To: pgsql-hackers@lists.postgresql.org

Date: 2024-11-18T20:21:56Z

Lists: pgsql-hackers

Attachments

v1-0001-PGSERVICEFILE-as-part-of-the-connection-string.patch (text/x-patch) patch v1-0001

Hi,

I like to bundle all my database connections in a .pg_service.conf. Over
time I collected a bunch of such service files. A while back I discovered
that the service file can only be specified as an environment variable. It
cannot be given as part of the connection string like

psql "service=$MY_SERVICE servicefile=MY_SERVICE_FILE"

The attached patch allows that.

Regards.
--
Torsten

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

psql: Add variable SERVICEFILE
- 6b1c4d326b06 19 (unreleased) landed
libpq: Add "servicefile" connection option
- 092f3c63efc6 19 (unreleased) landed
libpq: Add TAP test for nested service file
- df286a5b830a 19 (unreleased) landed
libpq: Fix some issues in TAP tests for service files
- 2c7bd2ba507e 18.0 landed
docs: Fix column count attribute in table
- ea3f9b6da34a 18.0 cited
libpq: Add TAP tests for service files and names
- 72c2f36d5727 18.0 landed