| From: | John Scalia <jayknowsunix(at)gmail(dot)com> |
|---|---|
| To: | John Scalia <JAYKNOWSUNIX(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Showing materialized views |
| Date: | 2021-01-07 14:06:06 |
| Message-ID: | 721780BB-68A6-47FA-A14C-2D8C88B9155D@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Never mind, I had not attempted to use \dm and that does seem to show the materialized views. My bad.
Sent from my iPad
> On Jan 7, 2021, at 8:41 AM, John Scalia <JAYKNOWSUNIX(at)gmail(dot)com> wrote:
>
> I understand that materialized views are a relatively new addition to pg, and I’m only running version 11.8, but has there been any effort to providing a simple \ command, like \dv to show them? It seems easy enough to add when I look at the query behind a \dv run.
> —
> Jay
>
> Sent from my iPad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henry Francisco Garcia Cortez | 2021-01-07 16:56:33 | Re: autovacuum_analyze_scale_factor and autovacuum_analyze_scale_factor |
| Previous Message | John Scalia | 2021-01-07 13:41:56 | Showing materialized views |