yUsEEzpb

1CREATE SCHEMA IF NOT EXISTS lib;
2
3CREATE TABLE IF NOT EXISTS lib.configs(c jsonb NOT NULL); -- one-row table, all in a JSONb
4INSERT INTO lib.configs(c) SELECT '{}'::JSONb  
5WHERE NOT EXISTS (
6  SELECT * FROM lib.configs LIMIT 1
7);
8UPDATE lib.configs SET c = c || jsonb_build_object(
9    'str_TitlePreps_array-pt-BR',to_jsonb( array[
10      'EM', 'NA', 'NO', 'NOS, NAS', 'COMO', 'COM', 'PARA','POR', 'PELO', 'PELA', 'PELOS', 'PELAS', 'DE','DA'
11      ,'DO', 'DOS', 'DAS', 'E', 'A', 'O', 'AS', 'OS', 'AO', 'AOS', 'É', 'À', 'ÀS', 'UMA', 'UM', 'OU', 'E/OU'
12      ,'QUE', 'AQUELES', 'AQUELE', 'AQUELA', 'AQUELAS', 'ENTRE', 'ANTE', 'SEU', 'SUA', 'SOB', 'SOBRE', 'APÓS'      
13    ] )
14    ,'str_PersonNamePreps_array-pt-BR',to_jsonb( array['DA','DO','DAS','DOS','DE','E'] )
15   -- etc a little more configs
16);