PostgreSQL Enum Support

🚀 NocoDB : Feature Release

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