Re: Materialized views WIP patch

On 02/19/2013 02:09 PM, Erik Rijkers wrote:
> On Sat, February 16, 2013 02:01, Kevin Grittner wrote:
>> matview-v4.patch.gz
>
> Hi,
>
> I was wondering if material views should not go into information_schema. I was thinking either
> .views or .tables. Have you considered this?
>
> I ask because as far as I can see querying for mv's has to go like this:
>
> SELECT n.nspname, c.relname
> FROM pg_catalog.pg_class c
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
> WHERE c.relkind IN ('m','')
> and n.nspname = 'myschema'

Well, I'm not sure about information_schema, but we'll definitely want a
pg_matviews system view. Also a \dM. That could wait until 9.4, though.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com