title: PostgreSQL Equivalent of SQLServer's NoLock Hint
body: <p>In SQLServer, you can use syntax "(nolock)" to ensure the query doesn't lock the table or isn't blocked by other queries locking the same table.
  e.g.</p>
  
  <pre><code>SELECT * FROM mytable (nolock) WHERE id = blah
  </code></pre>
  
  <p>What's the equivalent syntax in Postgres? I found some documentation on table locking in PG (<a href="http://www.postgresql.org/docs/8.1/interactive/sql-lock.html" rel="noreferrer">http://www.postgresql.org/docs/8.1/interactive/sql-lock.html</a>), but it all seems geared at how to <em>lock</em> a table, not ensure it's <em>not locked</em>.</p>