Add PostgreSQL Hstore extension to structure.sql (HACK

hstore_extension.db.rake

namespace :db do
  namespace :structure do
    task :add_hstore_extension do
      puts "HACK! Adding `CREATE EXTENSION hstore SCHEMA hstore;` to structure.sql (see db_strucute_dump.rake)"

      structure_dump = Rails.root + "db/structure.sql"
      new_structure_dump = Rails.root + "db/new_structure.sql"

      new_file = File.open(new_structure_dump, 'w')
      existing = File.open(structure_dump)

      existing.each do |line|
        new_file << line
        if line == "CREATE SCHEMA hstore;\n"
          new_file << "CREATE EXTENSION hstore SCHEMA hstore;"
        end
      end

      existing.close
      new_file.close
      FileUtils.mv(new_structure_dump, structure_dump)
    end
  end
end

Rake::Task["db:structure:dump"].enhance do
  Rake::Task["db:structure:add_hstore_extension"].invoke
end

influitive/apartment#51 (comment)