title: How to open psql prompt for PostgreSQL in FreeBSD?
body: <p>I have installed PostgreSQL on my FreeBSD 8.2 box. How can I open the SQL prompt so I can write SQL queries?</p>
  
  <p>I can do:</p>
  
  <pre><code>su pgsql
  </code></pre>
  
  <p>Which opens a prompt but I cannot write SQL queries like SELECT or CREATE there. Sorry, I am new to PostgreSQL.</p>