title: I keep getting the error "relation [TABLE] does not exist"
body: <p>I have been trying to query two tables in my database. In the server explorer I can see both tables and even see the columns within them. We'll call them Schema.table1 and Schema.table2 where "Schema" has its first letter capitalized. I have tried running the following queries: </p>
  
  <pre><code>select * from Schema.table1;
  </code></pre>
  
  <p>Where I get the following error: </p>
  
  <blockquote>
    <p>ERROR: relation "schema.table1" does not exist</p>
  </blockquote>
  
  <p>I then tried running the next query thinking maybe the capitalization in the schema made a difference.</p>
  
  <pre><code>Select * from "Schema.table1"; 
  select "ID" from "Schema.table1";
  </code></pre>
  
  <p>But the same error persisted:</p>
  
  <blockquote>
    <p>ERROR: relation "Schema.table1" does not exist</p>
  </blockquote>
  
  <p>I later tried to specify the schema path with "SET search_path to "Schema1" and ran a query on the tables which again provided me the same error. Any ideas or help would be greatly appreciated.</p>