title: How can I convert all columns in my database to case insensitive
body: <p>I have seen that it is possible to convert all <strong>tables</strong> to case insensitive names using the following commands in psql:</p>
  
  <pre><code>\o /tmp/go_to_lower
  select 'ALTER TABLE '||'"'||tablename||'"'||' RENAME TO ' ||
  lower(tablename)||';' from pg_tables where schemaname = 'public';
  psql -U username database &lt; /tmp/go_to_lower
  </code></pre>
  
  <p>I have been unable to unearth a command to convert all <strong>columns</strong> to case insensitive in the same way. How can this be achieved?</p>
  
  <p>EDIT: Apparently the above code only converts table names to lower case. I am aware that this code ALTER TABLE "YourTableName" RENAME TO YourTableName; will convert to case insensitive for a table name. Is there a way to do a similar function on mass for column names?</p>