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

Question

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?

score 89 · Accepted Answer · edited Jan 22 '19 at 13:10

89

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

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

edited Jan 22 '19 at 13:10

Rudolf Manusachi

2,311
2
19
25

answered Oct 20 '15 at 18:52

Brian

916
7
5

Works as it should. – W.M. Jan 11 '19 at 11:43
I'm guessing that the reason this doesn't work for me is we still have MySql 5, so I think this answer is applicable to MySql 8 or higher. – Sinc May 08 '23 at 16:12

score 5 · Answer 2 · answered Jul 11 '15 at 08:30

5

We don't have an option to rename columns yet. You will need to consult your database documentation and issue a SQL statement with execute.

answered Jul 11 '15 at 08:30

José Valim

50,409
12
130
115

1

OK cool, I'll create the blank migration and add my own SQL :) – TheStoneFox Jul 11 '15 at 11:33

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

2 Answers2