© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•3y ago
algoguy

How to create jsonb attribute index in drizzle

Suppose I have a table
Books
  author: varchar
  extra: jsonb
Books
  author: varchar
  extra: jsonb


I want to create an index on extra ->> 'createdDate', how do I do this in drizzle
I know this is possible in postgres, just want to know if its possible on drizzle with sql operator? or should I create this manually
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

planetscale: how to index col using drizzle?
Drizzle TeamDTDrizzle Team / help
3y ago
How to create unique lowercase index?
Drizzle TeamDTDrizzle Team / help
3y ago
Updating jsonb objects with Drizzle?
Drizzle TeamDTDrizzle Team / help
3y ago
How to set a GIN index on the JSONB column?
Drizzle TeamDTDrizzle Team / help
2y ago