sqldatabasepostgresqlsupabasesupabase-database

How can I create an enum column in Supabase?

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?

Solution

  • 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