Re: alter system appending to a value

2025-04-30 Thread Greg Sabino Mullane
On Wed, Apr 30, 2025 at 7:15 AM Luca Ferrari wrote: > 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. > Ansible is good for bringing your systems to a known consistent s

Re: alter system appending to a value

2025-04-30 Thread Victor Yegorov
ср, 30 апр. 2025 г. в 14:15, Luca Ferrari : > 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'; > I would do smth like: SELECT format( '