alter system appending to a value
Luca Ferrari <fluca1978@gmail.com>
From: Luca Ferrari <fluca1978@gmail.com>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2025-04-30T11:14:29Z
Lists: pgsql-general
Hi all, as trivial as it sounds, is there a smart way to use ALTER SYSTEM to append to a value? Something like: ALTER SYSTEM shared_preloaded_libraries = current_setting( 'shared_preloaded_libraries' ) || ',foo'; Rationale: I'm using ansible to configure, thru different steps, PostgreSQL instances and I would like to have every part to append its configuration on the previous one. Thanks, Luca