论坛 › PostgreSQL › postgresql怎么用change.column

wslhs 发表于 2016-11-20 08:43:09

postgresql怎么用change.column

def up
connection.execute(%q{
alter table contests
alter column prize type integer using cast(prize as integer),
alter column price set default 200
})
end
def up
case ActiveRecord::Base.connection
when ActiveRecord::ConnectionAdapters::PostgreSQLAdapter
connection.execute(%q{
alter table contests
alter column prize type integer using cast(prize as integer),
alter column price set default 200
})
when ActiveRecord::ConnectionAdapters::MySQLAdapter
# MySQL version...
end
end


rails 中怎么truncate table

ActiveRecord::Base.connection.execute("TRUNCATE TABLE #{table_name}")

查看完整版本: postgresql怎么用change.column