Re-order columns in Supabase Studio?
Hey 👋
Is there a way to do an actual re-ordering in the columns of a table? I know we can drag the columns but it re-orders only locally (through
localStorage). I would instead prefer to re-order for everyone at the same time (see screenshot attached)
Maybe through some SQL statements?
Cheers!
3 Replies
I feel a drop & re-create the table is in order
It is non trivial to reorder columns in postgres....
Just one link on it...
https://stackoverflow.com/questions/285733/how-do-i-alter-the-position-of-a-column-in-a-postgresql-database-table
Stack Overflow
How do I alter the position of a column in a PostgreSQL database ta...
I've tried the following, but I was unsuccessful:
ALTER TABLE person ALTER COLUMN dob POSITION 37;
oh well, thanks for the input @garyaustin