How to add a new column in existing table after a specified column.

[krzywiecki]

Hey guys, asking this question after not so successful internet research.

Basically, I need to add a new column to an existing table. By default, it adds a new column at the end but what I need to do is to add the column after another specific column. I tried to do this:

pgm.addColumns('mbb_channels', {
        budget_gross_cents: { 
            type: 'integer', 
            notNull: true,
            default: 0,
            after: 'budget_gross'
        },
});

but looks like the after property isn't supported.

Is there a way to achieve it?

[GabenGar]

Why do you need "after" specifically? The column order shouldn't matter and if it does matter for the context of a query, you will name them in a specific order within it.

[moltar]

This is a PostgreSQL limitation. There is no way to add columns after another column, like in MySQL.