title: Cannot simply use PostgreSQL table name ("relation does not exist")
body: <p>I'm trying to run the following PHP script to do a simple database query:</p>
  
  <pre><code>$db_host = "localhost";
  $db_name = "showfinder";
  $username = "user";
  $password = "password";
  $dbconn = pg_connect("host=$db_host dbname=$db_name user=$username password=$password")
      or die('Could not connect: ' . pg_last_error());
  
  $query = 'SELECT * FROM sf_bands LIMIT 10';
  $result = pg_query($query) or die('Query failed: ' . pg_last_error());
  </code></pre>
  
  <p>This produces the following error:</p>
  
  <blockquote>
    <p>Query failed: ERROR: relation "sf_bands" does not exist</p>
  </blockquote>
  
  <p>In all the examples I can find where someone gets an error stating the relation does not exist, it's because they use uppercase letters in their table name. My table name does not have uppercase letters. Is there a way to query my table without including the database name, i.e. <code>showfinder.sf_bands</code>?</p>