Postgres 12

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'