is it possible to get a list of enum values using prisma client?

Hey @John Cantrell 👋 You can use

prisma.queryRaw

to get the enum values. Something like this should work for Postgres:

await prisma.queryRaw`select unnest(enum_range(null::enum_name))`

A similar question was asked in the BLitz Slack, and there I answered:

The answer is, you don’t need query raw, you can literally just import the enum like so:

schema.prisma

enum Tree {
  ARBORVITAE
  YELLOWBIRCH
  BLACKASH
  DOUGLASFIR
  OAK
}

file.ts

import { Tree } from '@prisma/client'

console.log(Tree)

logs:

{
  ARBORVITAE: 'ARBORVITAE',
  YELLOWBIRCH: 'YELLOWBIRCH',
  BLACKASH: 'BLACKASH',
  DOUGLASFIR: 'DOUGLASFIR',
  OAK: 'OAK'
}