title: Add element to sub element of JSON object
body: <p>I have a table named ext_conf having one of the columns named data of dataType jsonb in it. The content of the field looks something like this:</p>
  <pre><code>{
  &quot;name&quot;: &quot;main_profile_name&quot;,
  &quot;skipOption&quot;: {
      &quot;name&quot;: &quot;instance&quot;,
      &quot;value&quot;: 1
  },
  &quot;description&quot;: &quot;main_profile&quot;,
  &quot;integration&quot;: false,
  &quot;integrationType&quot;: {
      &quot;name&quot;: &quot;download&quot;,
      &quot;typeValue&quot;: &quot;EXPORT&quot;
  },
  &quot;processParameters&quot;: [
      {
          &quot;name&quot;: &quot;SrcFile&quot;,
          &quot;defaultVal&quot;: &quot;Time*&quot;,
          &quot;userPrompt&quot;: true,
          &quot;paramType&quot;: {
              &quot;name&quot;: &quot;text&quot;
          },
          &quot;templateParameter&quot;: &quot;SrcFile&quot;
      },
      {
          &quot;name&quot;: &quot;directory&quot;,
          &quot;defaultValue&quot;: &quot;/back&quot;,
          &quot;userPrompt&quot;: false,
          &quot;paramType&quot;: {
              &quot;name&quot;: &quot;Text&quot;
          },
          &quot;templateParameter&quot;: &quot;directory&quot;
      }
  ],
  &quot;integrationProcess&quot;: {
      &quot;name&quot;: &quot;My-v1&quot;
  },
  &quot;allowMinuteInterval&quot;: true,
  &quot;connectionDefinition&quot;: {
      &quot;name&quot;: &quot;cloud&quot;
  }
  }
  </code></pre>
  <p>I need to update processParameters and add a few more elements to it so that it looks like:</p>
  <pre><code>{
  &quot;name&quot;: &quot;main_profile_name&quot;,
  &quot;skipOption&quot;: {
      &quot;name&quot;: &quot;instance&quot;,
      &quot;value&quot;: 1
  },
  &quot;description&quot;: &quot;main_profile&quot;,
  &quot;integration&quot;: false,
  &quot;integrationType&quot;: {
      &quot;name&quot;: &quot;download&quot;,
      &quot;typeValue&quot;: &quot;EXPORT&quot;
  },
  &quot;processParameters&quot;: [
      {
          &quot;name&quot;: &quot;SrcFile&quot;,
          &quot;defaultVal&quot;: &quot;Time*&quot;,
          &quot;userPrompt&quot;: true,
          &quot;paramType&quot;: {
              &quot;name&quot;: &quot;text&quot;
          },
          &quot;templateParameter&quot;: &quot;SrcFile&quot;
      },
      {
          &quot;name&quot;: &quot;directory&quot;,
          &quot;defaultValue&quot;: &quot;/back&quot;,
          &quot;userPrompt&quot;: false,
          &quot;paramType&quot;: {
              &quot;name&quot;: &quot;Text&quot;
          },
          &quot;templateParameter&quot;: &quot;directory&quot;
      },
      {
          &quot;name&quot;: &quot;MovedProcessed&quot;,
          &quot;defaultValue&quot;: &quot;/temp&quot;,
          &quot;userPrompted&quot;: true,
          &quot;parameterType&quot;: {
              &quot;name&quot;: &quot;Text&quot;
          },
          &quot;templateParameter&quot;: &quot;MovedProcessed&quot;
      },
      {
          &quot;name&quot;: &quot;Root&quot;,
          &quot;userPrompted&quot;: false,
          &quot;parameterType&quot;: {
              &quot;name&quot;: &quot;Text&quot;
          },
          &quot;templateParameter&quot;: &quot;Root&quot;
      }
  ],
  &quot;intProcess&quot;: {
      &quot;name&quot;: &quot;My-v1&quot;
  },
  &quot;interval&quot;: true,
  &quot;connDef&quot;: {
      &quot;name&quot;: &quot;cloud&quot;
  }
  }
  </code></pre>
  <p>I am new to it and trying to write SQL but fail to do so, Is there a way to do this in Postgres?</p>