activerecordからpostgresql使う

出力

==  MessageInit: migrating ====================================================
-- create_table(:messages)
NOTICE:  CREATE TABLE will create implicit sequence "messages_id_seq" for serial column "messages.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "messages_pkey" for table "messages"
   -> 0.1686s
==  MessageInit: migrated (0.1690s) ===========================================

user1@うふふ
user2@あはは

ar-test.rb

#/usr/bin/ruby

require 'rubygems'
require 'active_record'

ActiveRecord::Base.establish_connection(
                                        :adapter => 'postgresql',
                                        :host => 'localhost',
                                        :username => 'ar_user',
                                        :password => 'ar_pass',
                                        :database => 'ar-test'
                                        )

class MessageInit < ActiveRecord::Migration
  def self.up
    create_table(:messages){|t|
      t.string :name, :limit => 20, :null => false
      t.string :text,:limit => 30, :null => false
     }
  end

  def self.down
    drop_table :messages
  end
end

MessageInit.migrate(:up)
#MessageInit.migrate(:down)

# model
class Message < ActiveRecord::Base
  def to_s
    return  "#{name}@#{text}"
  end
end

Message.create(
               :name => 'user1',
               :text => 'うふふ'
               )

Message.create(
               :name => 'user2',
               :text => 'あはは'
               )

Message.find(:all).each{ |m|
  puts m.to_s
}