title: Why PostgreSQL does not like UPPERCASE table names?
body: <p>I have recently tried to create some tables in PostgreSQL all in uppercase names. However in order to query them I need to put the table name inside the quotation  &quot;TABLE_NAME&quot;. Is there any way to avoid this and tell the postgres to work with uppercase name as normal ?</p>
  <p><strong>UPDATE</strong></p>
  <p>this query create a table with lowercase <em><strong>table_name</strong></em></p>
  <pre><code>create table TABLE_NAME 
  (
  id integer,
  name varchar(255)
  )
  </code></pre>
  <p>However, this query creates a table with uppercase name <em><strong>&quot;TABLE_NAME&quot;</strong></em></p>
  <pre><code>create table &quot;TABLE_NAME&quot;
  (
  id integer,
  name varchar(255)
  )
  </code></pre>
  <p>the problem is the quotations are part of the name now!!
  in my case I do not create the tables manually, another Application creates the table and the names are in capital letters. this cause problems when I want to use <a href="http://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html" rel="noreferrer">CQL</a> filters via Geoserver.</p>