title: Switching from MySQL to PostgreSQL - tips, tricks and gotchas?
body: <p>I am contemplating a switch from MySQL to PostgreSQL.</p>
  
  <p>What are your tips, tricks and gotchas for working with PostgreSQL?</p>
  
  <p>What should a MySQLer look out for?</p>
  
  <blockquote>
    <p>See also: <a href="https://stackoverflow.com/questions/724867/how-different-is-postgresql-to-mysql">How different is PostgreSQL to MySQL?</a><br />
    See also: <a href="https://stackoverflow.com/questions/2831009/migrate-from-mysql-to-postgresql-on-linux-kubuntu/2831517">Migrate from MySQL to PostgreSQL</a></p>
  </blockquote>
  
  <p><strong>Note - I don't think this is a duplicate. In particular the type of answers are quite diffferent and the responses here have much more implementation detail, which is what I was looking for</strong></p>