title: Partition with two columns in PostgreSQL
body: <p>I would like to partition my table within two columns. I have Data like :</p>
  
  <pre><code>date       numero   demande     action
  01/02/2020  2011-3  1          SUPPRESSION
  01/02/2020  2011-3  1          OPPOSITION
  01/02/2020  2011-3  1          DATA
  01/09/2020  2011-3  1          OPPOSITION
  01/09/2020  2011-3  1          SUPPRESSION
  01/09/2020  2011-3  1          SUPPRESSION
  01/02/2020  2011-3  1          DATA
  </code></pre>
  
  <p>I have more than 20k thousand lines and I would like to partition with date (varchar) and with action. </p>
  
  <p>I tried to to this with Postgresql :</p>
  
  <pre><code>CREATE TABLE helloone (date varchar,
                        numero varchar,
                        demande varchar,
                        action varchar)
  PARTITION BY RANGE (date,action);
  </code></pre>
  
  <p>But I have no idea on the next step to have the result I need. Thank you !</p>