title: How to change the order of an existing postgres enum
body: <p>I have a postgres enum that would like to change its default sort order</p>
  
  <p>I learned about the pg_enum type <a href="https://www.postgresql.org/docs/11/catalog-pg-enum.html" rel="nofollow noreferrer">enumsortorder</a> but haven't found any documentation on how to change the order.</p>
  
  <p>The enum I have for context: </p>
  
  <pre><code>CREATE TYPE day AS ENUM (
              'everyday', 
              'sunday',
              'monday',
              'tuesday',
              'wednesday',
              'thursday',
              'friday',
              'saturday'
            );
  </code></pre>
  
  <p>Currently when I retrieve ordered by day I get from 'everyday' to 'saturday'. I would like to get from Monday-Sunday and have Everyday as the last value.</p>
  
  <p>Is this possible?</p>