Update column in postgresql to ARRAY[]::text[] doesnt work

Support
1

Hi all,

Im trying to change the value to an empty arrray, when I do like below I get curly brackets in the field and not square brackets, how can I do that?

I change the key_type to array and I want to change the value to square brackets .

grafik
grafik1377×52 1.97 KB

foreman=# UPDATE parameters SET value = ARRAY::text where name = ‘mycustomparam’;

Foreman and Proxy versions: foreman 3.6.1 , foreman-proxy 3.6.1

Distribution and version: Ubuntu 20.04.4 LTS

thanks in advance