title: CTE and temporary index on PostgreSQL
body: <p>I work on postgres database where I'll using a mix of relational tables and jsonb tables (which can be indexed).</p>
  
  <p>I have being using a lot of CTE queries to insert or update data selecting from a temporary table, like:</p>
  
  <pre><code>WITH information as (
      select fieldA, fieldB, fieldC from tableA
  )
  insert (fieldA, fieldB, fieldC)
  SELECT inf.fieldA, inf.fieldB, inf.fieldC
  from information inf
  </code></pre>
  
  <p>Well, I would like to know if it's possible create temporary index in this kind of tables and if is, is possible create index in jsonb type fieds too? (considering this temporary tables)</p>