How can I create an enum column in Supabase?

Question

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?

score 27 · Accepted Answer · answered Aug 19 '22 at 08:15

27

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.

answered Aug 19 '22 at 08:15

Joel Lee

929
8
17

3

Is there a roadmap when this will come in? – funerr Dec 13 '22 at 20:21
1

^ Wondering this as well! Supabase is fantastic and would love to see this added. – aeviou Dec 16 '22 at 22:10
5

Hey all, Thanks for your patience so far - there isn't a roadmap at the moment but the frontend team has noted it in their list of tasks. They'll be be prioritising tasks at the beginning of 2023 and we'll get back to you once we have more details! – Joel Lee Dec 19 '22 at 06:50
How is it going @JoelLee , still highly interested in the enum feature, kind of essential – Branchverse Mar 22 '23 at 16:44

score 5 · Answer 2 · answered Apr 19 '23 at 14:39

I struggled with this a bit (haven't used SQL in years).

Here is how you can do it, by doing it using SQL directly from the SQL Editor.

CREATE TYPE employment_status_enum AS ENUM (
  'Active',
  'Inactive'
);

ALTER TABLE "employee"
ADD COLUMN employment_status employment_status_enum 
DEFAULT 'Inactive';

How can I create an enum column in Supabase?

2 Answers2