# PG view sync \[Feb 12\]

**URL:** <https://community.nocodb.com/t/pg-view-sync-feb-12/223>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223 "2022-11-03T08:05:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223/1 "2022-11-03T08:05:21Z")

</div>

> 🙋‍♂️ **kots** _asked_

## Hi all! I’m on v 0.84.10 after upgrading to the latest on Heroku. I have an external Postgres DB setup on my NocoDB project. While I can view all the tables, I still cannot see and access Materialised Views created and migrated by me. Please help!

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223/2 "2022-11-03T08:05:22Z")

</div>

> 💁 **o1lab** _replied_

#### [https://docs.nocodb.com/setup-and-usages/sync-schema](https://docs.nocodb.com/setup-and-usages/sync-schema)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223/3 "2022-11-03T08:05:23Z")

</div>

> 🙋‍♂️ **kots** _replied_

#### Hello and thank you for the prompt reach out - I had tried the above before posting here 😦

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223/4 "2022-11-03T08:05:25Z")

</div>

> 💁 **o1lab** _replied_

#### dstala@discord will help

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223/5 "2022-11-03T08:05:26Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### kots@discord, happy to help. Will DM

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223/6 "2022-11-03T08:05:27Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### Thanks kots@discord for sync up over Zoom. Created a issue ticket for enhancement- to support PG Materialized views.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223/7 "2022-11-03T08:05:28Z")

</div>

> 👨‍🦲 **dstala** _replied_

#### [🔦 Feature: Support for PG materialized views · Issue #1157 · nocodb/nocodb · GitHub](https://github.com/nocodb/nocodb/issues/1157)

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 8:05am UTC](https://community.nocodb.com/t/pg-view-sync-feb-12/223/8 "2022-11-03T08:05:29Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/941306232906600460)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)