By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE OR REPLACE FUNCTION f_array_to_string_with_quotes(_arr text[], _quote text = '"')
RETURNS text LANGUAGE sql IMMUTABLE PARALLEL SAFE AS
$func$
SELECT $2 || array_to_string($1, $2 || ', ' || $2) || $2
$func$;
-- double quotes
SELECT f_array_to_string_with_quotes('{"Boa vista",Urbana,Rural,Indigena}', '"');
| f_array_to_string_with_quotes |
|---|
| "Boa vista", "Urbana", "Rural", "Indigena" |
-- same since " is default for $2
SELECT f_array_to_string_with_quotes('{"Boa vista",Urbana,Rural,Indigena}');
| f_array_to_string_with_quotes |
|---|
| "Boa vista", "Urbana", "Rural", "Indigena" |
-- single quotes
SELECT f_array_to_string_with_quotes('{"Boa vista",Urbana,Rural,Indigena}', '''');
| f_array_to_string_with_quotes |
|---|
| 'Boa vista', 'Urbana', 'Rural', 'Indigena' |