postgres: concat string with array
<p>Assume we have a column with text with next structure: <code>["A", "B", "C"]</code>,
how to concat it with array <code>ARRAY['A','C','D','E']</code> and produce string <code>["A", "B", "C", "D", "E"]</code> (string without repeated elements)?</p>

<p>postgres version is 9.4.8</p>

<p>Column data can be <code>["A", "B", "C"]</code> or null, how it can be concatenated with <code>ARRAY['A','C','D','E']</code> (actually it can be a string, but i need to add elements to existing string without repeating them), resulting string must have the following pattern <code>["A", "B", "C", "D", "E"]</code></p>

<p>Solved with script, that alternate db via pdo.</p>