How can I create an enum column in Supabase?
Aug 18
I want to create an enum column in a Supabase table. Supabase uses Postgres under the hood, so I understand that technically it is possible if I do it manually using SQL. But is there any way I can do it via the frontend in an easier manner?
supabase
postgresql1 answer
Accepted answer · original discussion
Aug 19
Supabase engineer here -- Thanks for the query! You are right that Supabase uses Postgres under the hood and that it can be done via the SQL editor on the Supabase dashboard or directly against the database by using psql.
To my knowledge we don't have a way of entering enum types via the frontend as of yet. We will relay this piece of feedback to the frontend team though.
Let us know if you have any further questions.
Update: Frontend team has shipped Enums - please check https://supabase.com/dashboard/project/_/database/types
Your perspective belongs here.
Sign in with a verified account to contribute.
0 question comments
Use comments to ask for clarification. Post a solution as an answer.
No question comments on this page.