How to alter a column name in an Ecto model with a migration?

elixir ecto
TheStoneFox picture TheStoneFox · Jul 11, 2015 · Viewed 10.8k times · Source

Does anyone know of (or can provide) an example of how to alter a table column name using the ecto DSL

I'm guessing I just use mix ecto.gen.migration but then would I just fill in the empty created file with my custom code (if so, how would you edit a column name, the docs show modify to change the column type)

or is there a command line flag I can pass to generate the migration code for me?

Answer

Brian picture Brian · Oct 20, 2015

You can now do that with Ecto.Migration.rename/3:

rename table(:posts), :title, to: :summary

Related questions

Turn postgres date representation into ISO 8601 string

I'm trying to format a Postgres date representation into a ISO 8601 string. I'm assuming that there is a Postgres function that can do it, but I found the documentation short on examples. My query is SELECT now()::timestamp which returns [{{2016, 8, 9}, {3, 56, 55, 754181}}] …

Read More
How to use raw sql with ecto Repo

I have an upsert requirement, so I need to call a postgres stored procedure or use a common table expression. I also use the pgcrypto exgtension for passwords and would like to use postgres functions (such as "crypt" to encode/…

Read More
Is there a Phoenix equivalent to Rails Console

I'm just learning Phoenix and Elixir and I'm coming from Ruby/Rails where I work in the REPL using pry to inspect my database and application state. I'm trying to figure out how to interact with my database and models …

Read More