Postgresql ENUM type

DBML Syntax
1

Hi there,

I love the tool as I find it very easy to create a simple diagram for reference but I can’t figure out how to properly define a Postgresql enum type, only setting the column type as generic “enum”.

Is this supported?

Many thanks

2

Many thanks for your note @garcianavalon, we’re actually already working on this feature and will release it soon. When released, it will be:

Enum job_status {
  created [note: "Job created and pending"]
  running [note: "Waiting for warehouse to process"]
  done
  failed
  'wait for validation' [note : "Enum label that has white spaces"]
}

Table jobs {
  id integer [pk]
  status job_status
}
2 Likes
3

Thanks for the quick answer @huy!

Looks good, looking forward to the release