Showing materialized views

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Showing materialized views

Jay at Verizon
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

Reply | Threaded
Open this post in threaded view
|

Re: Showing materialized views

Jay at Verizon
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 <[hidden email]> 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