Materialized View from NestJS/TypeORM project

I'm trying to create a Materialized view from my NestJS app using TypeORM. The database is a Postgres.

View Entities unfortunately doesn't match requirements: https://www.bookstack.cn/read/TypeORM/view-entities.md

Wished behaviour: just like models, a materialized view is defined in the NestJS project, with the option 'synchronize:true' : the project creates the view on running if it doesn't exist, if it exist, it just sync with it (just like models).

Is there any leads that would help me achieving this?

Solution

What I ended up doing was defining the entity as a ViewEntity, setting {materialized:true}.

However, as you noted, typeorm doesn't handle this so well. I ended up disabling synchronization in the ormconfiguration and running migrations when I wanted to change things in the entity.

However, once the entity is created, typeorm works out of the box really well.

How to fix the error "no pg_hba.conf entry for host" from Heroku in NestJS
How to use 'require' to import a JSON in NestJS controller?
Unicode special character U+FFFD returning from my Nest.JS API, but only sometimes
In the next major version, Nest will not allow classes annotated with @Injectable(), @Catch(), and @Controller() decorators
TypeOrm Error : Relation with property path xxx in entity was not found
Is there a recommended way to update NestJS?
Validation an object with at least one non-nullable field
Nest JS and Typescript with SWC is not compiling dist folder correctly
NestJS Application, `Cannot find module "express"` when installing dependencies in production mode with pnpm
mongoose model.save() return TypeError: callback is not a function
Registered Nest.js interceptor not being used for dependency injection
[NestJs]: JwtModule.register() not working
Test coverage: import statements not covered
Audit logs with TypeORM and NestJS
Error Connecting to RDS AWS DB from nestjs Unable to get local issuer Certificate
Email template issue using handlebars js in nest js
How to get HTTP request, then share the info with a Gateway provider. Nest.js
Argument of type 'string' is not assignable to parameter of type 'never' on prisma.service
Nestjs swagger array of strings with one parameter
Nest.js - DTO validation and transforming string to date
Nestjs/Jest Is there a way to override Module in imported Module in e2e test
How to create a shared package in a Turborepo (monorepo), for prisma generated models and types?
Sqlite datetime saves one day less than the original input
Nest.JS with TypeORM How to entity member Buffer type casting?
Is there a way to programmatically override a datasource url with nest config?
Getting "The 'mongodb' provider is not supported with this command" Error when try to do mongoDB migrate with Prisma
Why doesn't my QR Code show up when streamed from the server
not able to use pre save mongoose hook in nestJs
How do I automatically sign a user in (create session and send cookie back) after they sign up using a Nest.js backend with Passport?
Nestjs - There is no matching event handler defined in the remote service