Re: Append to a GUC parameter ? - Mailing list pgsql-hackers

+1

With a very simple statement you can do that:

fabrizio=# SELECT current_setting('search_path');
 current_setting
-----------------
 "$user",public
(1 row)

fabrizio=# SELECT set_config('search_path', current_setting('search_path')||', another_schema', false);
           set_config          
--------------------------------
 "$user",public, another_schema
(1 row)

Or you can create a simple sql function to concat your configs:

fabrizio=# CREATE FUNCTION concat_config(name TEXT, value TEXT, is_local BOOLEAN)
fabrizio-# RETURNS text
fabrizio-# LANGUAGE sql
fabrizio-# AS $$ SELECT set_config(name, current_setting(name)||','||value, is_local); $$;
CREATE FUNCTION
fabrizio=# SELECT concat_config('search_path', 'another_schema', false);
         concat_config        
-------------------------------
 "$user",public,another_schema
(1 row)

fabrizio=# SELECT concat_config('search_path', 'schema2', false);
             concat_config            
---------------------------------------
 "$user",public,another_schema,schema2
(1 row)

Regards,