# Postgres 'materialized\_view' not found for adapter postgres

**URL:** <https://discourse.getdbt.com/t/postgres-materialized-view-not-found-for-adapter-postgres/8977>\
**Category:** Help\
**Tags:** postgres\
**Created:** [July 4, 2023, 9:50am UTC](https://discourse.getdbt.com/t/postgres-materialized-view-not-found-for-adapter-postgres/8977 "2023-07-04T09:50:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![AndreasEisenberger](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@AndreasEisenberger](https://discourse.getdbt.com/u/AndreasEisenberger)\
**Post date:** [July 4, 2023, 9:50am UTC](https://discourse.getdbt.com/t/postgres-materialized-view-not-found-for-adapter-postgres/8977/1 "2023-07-04T09:50:39Z")

</div>

Hello,  
I was trying to use ‘materialized\_view’ for a SQL model but I get this error message. I used the implementation from [Postgres configurations | dbt Developer Hub](https://docs.getdbt.com/reference/resource-configs/postgres-configs#materialized-view)

{{  
config(  
materialized = ‘materialized\_view’,  
on\_configuration\_change = ‘apply’,  
)  
}}

But I get this error when doing “dbt run”:

No materialization ‘materialized\_view’ was found for adapter postgres! (searched types ‘default’ and ‘postgres’)

I also just updated dbt-core and dbt-postgres:

Core:

- installed: 1.5.2
- latest: 1.5.2 - Up to date!

Plugins:

- postgres: 1.5.2 - Up to date!

Best regards

---

<div class="post-metadata">

**Author:** ![kinghuang](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/kinghuang/32/1291_2.png) [@kinghuang](https://discourse.getdbt.com/u/kinghuang)\
**Post date:** [July 14, 2023, 6:18pm UTC](https://discourse.getdbt.com/t/postgres-materialized-view-not-found-for-adapter-postgres/8977/2 "2023-07-14T18:18:08Z")

</div>

I’m guessing the documentation may have jumped the gun on that. Materialized view support was merged in quite recently, and is in the 1.6 series.