# File lib/jekyll/migrators/mephisto.rb, line 21 def self.postgres(c) sql = "BEGIN;\nCREATE TEMP TABLE jekyll AS\nSELECT title, permalink, body, published_at, filter FROM contents\nWHERE user_id = 1 AND type = 'Article' ORDER BY published_at;\nCOPY jekyll TO STDOUT WITH CSV HEADER;\nROLLBACK;\n" command = %Q(psql -h #{c[:host] || "localhost"} -c "#{sql.strip}" #{c[:database]} #{c[:username]} -o #{c[:filename] || "posts.csv"}) puts command `#{command}` CSV.process end