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