arbritrary_ddl.rb

require 'active_record'

spec = { adapter: :postgresql, database: :jgn }
ActiveRecord::Base.establish_connection(spec)

if ActiveRecord::Base.connection.table_exists?(:members)
  ActiveRecord::Base.connection.drop_table :members
  puts 'Dropped table'
end

# To get a feel for the methods like #create_table, see
#   http://guides.rubyonrails.org/active_record_migrations.html
#   http://guides.rubyonrails.org/active_record_migrations.html#creating-a-table
ActiveRecord::Base.connection.create_table :members do |table|
  # :id is the default primary key, and is created automatically
  table.string :first_name
  table.string :last_name
  table.string :type
end