Limitations

A list of Postgres features that no-orm does officially not support.

Views

A Postgres View will be ignored from no-orm. Just use tables instead - storage is relatively cheap these days.

Materialised views

A Postgres Materialised View will be ignored from no-orm.

Assumed schema isolation

A table in schema a cannot be referenced in a table from schema b and vice-versa:

CREATE TABLE a.table (
  -- ...
  b_reference REFERENCES b.table(id),
  -- ...
);

Also user-defined objects (enums, ranges etc) cannot be used across schemas.

Composite Types

A table with a Composite Type will be ignored. As discussed here.

Partial indexes

An index with a predicate will be ignored. As discussed here.

Functional indexes

An index with a predicate will be ignored. As discussed here.