title: postgresql: creating database in a specified location
body: <p>I am trying to create a PG db in a specified location. According to the docs <a href="http://www.commandprompt.com/ppbook/x17149" rel="noreferrer">here</a>, I must use the LOCATION flag. However, when I run <code>CREATE DATABASE (from the pgsql CLI)</code>, I get the following warning:</p>
  
  <pre><code>WARNING:  LOCATION is not supported anymore
  HINT:  Consider using tablespaces instead.
  </code></pre>
  
  <p>However, the PG documentation on TABLESPACES does not show how it can be used to create a database in a specific directory. What is the required syntax to do this?</p>