Support for ENUM? about mammoth HOT 2 CLOSED

Correct, this is not supported in the main branch right now. I'll get this back in.

As an alternative, you can use a text column but pass in your own type. This does not give you the database safety checks you get when you use a type, but it gives you the same safety checks in your application code. The downside of a postgres type is that you cannot remove a value (you can rename a value though).

The below creates a test column with a specific string union type.

export const test = defineTable({
  id: uuid().primaryKey().notNull().default('gen_random_uuid()'),
  test: text<'foo' | 'bar' | 'baz'>().notNull(),
});

from mammoth.

This is supported again. You can use the enumType(..) data type to configure this. I'll go through mammoth-cli as well to support creating and altering types as well.

export const test = defineTable({
  id: uuid().primaryKey().notNull().default('gen_random_uuid()'),
  test: enumType('my_enum_type', ['A', 'B', 'C'] as const).notNull(),
});

from mammoth.