github nocodb/nocodb 2026.04.5
2026.04.5: Postgres Enum Support

3 days ago

๐Ÿš€ NocoDB : Feature Release

2026 04 5 - OSS

PostgreSQL ENUM Support

PostgreSQL ENUM columns from external Postgres sources now show up as SingleSelect fields inside NocoDB. One of the most upvoted requests from the community (#4862), this closes a long-standing gap for teams who connect NocoDB to a Postgres database where ENUMs already define the allowed values.

Whether you're connecting NocoDB to an existing Postgres schema where ENUMs are the source of truth, building a hybrid stack where your application writes ENUM values and your team edits them in NocoDB, or simply wanting to enforce a fixed set of values closer to the data, ENUM columns now appear as proper select fields in NocoDB. Reads, writes, and round-trips stay type-safe, and the full set of allowed values is preserved end-to-end.

What's supported

  • Read ENUM columns from any connected Postgres source โ€” they appear as SingleSelect fields with the database's labels as options.
  • Edit ENUM values from grid, gallery, kanban, and expanded record views; the dropdown is restricted to the column's defined labels.
  • Add, rename, and remove options from inside NocoDB โ€” changes apply directly to the underlying Postgres ENUM type.
  • When the same ENUM type is shared by multiple columns, NocoDB safely forks a new type for the column being edited so changes don't leak to other columns using the same ENUM.
  • Filter, sort, group, and search ENUM fields exactly like any other SingleSelect.

Note: PostgreSQL ENUMs map to SingleSelect only in this release. ENUM array columns and MultiSelect-backed ENUMs are not yet supported.

Improvements and Fixes

  • Faster base load on large schemas - Bases with hundreds of tables now open noticeably faster, with table metadata streamed in as you scroll the sidebar.
  • CSV export honours active filters - Fixed an issue where exporting a filtered view would occasionally include rows hidden by the active filter set. Exports now match exactly what the view shows.
  • Shared Kanban views - Fixed an issue where shared Kanban views would fail to load when the stack-by column was hidden in the view.

Issues closed

  • [closed] Shared Kanban view fails to load when the group-by (stack-by) column is hidden in the view #13732
  • [closed] ๐Ÿ”ฆ Feature: Support for Right-to-Left (RTL) text direction in NocoDocs #13617
  • [closed] ๐Ÿ› Bug: APIv3 returns only 5 linked records in one-to-many field #13616
  • [closed] ๐Ÿ› Bug: Owner unable to send invitations to new members #13611
  • [closed] ๐Ÿ› Bug: pnpm bootstrap fails with TypeScript error -Property 'delete' does not exist on dbTableFilter in filterUtils.ts #13602
  • [closed] ๐Ÿ› Bug: Dragging records in Calendar Month View sets date to the first day of the week #13593
  • [closed] ๐Ÿ› Bug: ะกell of UUID type (read only) can be cleared #13588
  • [closed] ๐Ÿ› Bug/Feature: JSON export is incomplete and unusable as a database template #13493
  • [closed] ๐Ÿ”ฆ Feature: add autocomplete in Forms input fields #5913

Don't miss a new nocodb release

NewReleases is sending notifications on new releases.