Migration |> New foreign column on existing table |> after X column

Phoenix Forum Questions / Help
,
1

Hi!

I’m wondering if there is some way to choose the position of a new column while I’m modifying an existing table. On eloquent, for example, there is a function ->after()

I’m adding a foreign id column, and I would like it on the second position, instead last after the timestamps.

Thanks so much!

2

On MySQL, you can use the after option to add in a migration when adding the column.

1 Like
3

In Postgres - you can’t. More info: Alter column position - PostgreSQL wiki

2 Likes
4

Yes, it is Postgres… Sad to hear… painful to see.