title: What exactly do quotation marks around the table name do?
body: <p>I thought that the quotation mark (") was simply a type of grouping marker but I'm debugging some NHibernate code and notice that while</p>
  
  <pre><code>SELECT * FROM site WHERE site_id = 3;
  </code></pre>
  
  <p>Works fine</p>
  
  <pre><code>SELECT * FROM "site" WHERE site_id = 3;
  </code></pre>
  
  <p>fails with a table or view does not exist error.</p>
  
  <p>What gives?</p>