title: In postgresql, what's the difference a "database" and a "relation"? ('error relation x does not exist', 'error database x already exists')
body: <p>I see the juxtaposition of these two errors and, given the dearth of Google search results, had to ask. What is the difference and what do I need to be doing here?</p>
  
  <pre><code>deploy=# GRANT SELECT ON angel_research_production TO angel_research;
  ERROR:  relation "angel_research_production" does not exist
  deploy=# create database angel_research_production;
  ERROR:  database "angel_research_production" already exists
  </code></pre>
  
  <p>My guess is that I need to be doing this grant select business from some other user...</p>
  
  <p>So I run this on postgres (dbroot) and get this:</p>
  
  <pre><code>postgres=# GRANT SELECT ON angel_research_production TO angel_research;
  ERROR:  relation "angel_research_production" does not exist
  </code></pre>
  
  <p>So it does exist as a database, but not as a relation. How might I rectify this and what are the underlying issues here? I'm a little overwhelmed. Thanks</p>