Re: alter system appending to a value - Mailing list pgsql-general

From Victor Yegorov
Subject Re: alter system appending to a value
Date
Msg-id CAGnEbogyL+2w59QDQg9dbFcFvmbfYp2jWwOjW9FTtuS_z9Oivw@mail.gmail.com
Whole thread Raw
In response to alter system appending to a value  (Luca Ferrari <fluca1978@gmail.com>)
List pgsql-general
ср, 30 апр. 2025 г. в 14:15, Luca Ferrari <fluca1978@gmail.com>:
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( 'ALTER SYSTEM SET shared_preload_libraries = %L;', setting )
  FROM pg_settings WHERE name = 'shared_preload_libraries' \gexec

Of course, you should add new value to the existing setting, making sure there are no duplicates and the format is correct.

--
Victor Yegorov

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: alter system appending to a value
Next
From: PALAYRET Jacques
Date:
Subject: SQL ERROR subquery uses ungrouped column in PostgreSQL